Highlight Cell Question [Closed]

Report
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018
-
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
-
Hello,

I am trying to find a way to use conditional formatting on an inventory spreadsheet that I am working on. I would like to highlight cell C3 based on the relationship of the values of A3 and B3.

Example: if the value in A3 is greater than the value in B3, I would like C3 to shade the color green. However, if the value in A3 is less than the value in B3, I would like to shade C3 the color of red.

Thank you in advance for any help.

3 replies

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
DParson55, Good afternoon.

Try to use:
Select C3

1st RULE
Conditional Format --> Using formula --> =A3>B3
--> Format: Fill color as GREEN
OK

2nd RULE
Conditional Format --> Using formula --> =A3<B3
--> Format: Fill color as RED
OK

Please, tell us if it worked as you desired.
I hope it helps.
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018

That worked indeed. Thank you. One last piece that I neglected to mention, what would the formula be to highlight C3 green in the event that A3 and B3 were equal?
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
DParson55,

Simply change the first rule.

1st RULE
Conditional Format --> Using formula --> =A3>=B3
--> Format: Fill color as GREEN
OK

I hope it helps
--
Belo Horizonte, Brasil.
Marcílio Lobão
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018

What if I needed to make the "equal to" function yet a third color, say Yellow?
Posts
5
Registration date
Friday January 5, 2018
Status
Member
Last seen
February 14, 2018

Got it. Thank you again for your help!
Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
Glad to have helped you.

Have a nice weekend.
--
Belo Horizonte, Brasil.
Marcílio Lobão