Conditional formatting with Excel Closed

Question

Hello,

I'm making a doc where Column A has number values the same as column B and C. For each cell the conditional formating of cell in column C would be:
-if B > A and C > B: green
-if B < A and C < B: red
-and orange for the rest.

I would greatly appreciate all the help you coud give me.

Thanks

Trowa · Answer

Hi Agus,

I made a sheet look like this:

3	5	7
7	5	3
5	7	3

Then I selected this range (A1:C3) and changed the color to orange.

Then I selected A1:C1 and went to conditional formatting.
Change 1ste condition to "formula is" and enter the following formula:
=IF($B1>$A1,IF($C1>$B1,TRUE,FALSE))
and change color to green.
Then change the 2nd condition to "formula is" and enter this formula:
=IF($B1<$A1,IF($C1<$B1,TRUE,FALSE))
and change color to red.
Close conditional formatting screen by clicking OK.

Drag the range A1:C1 down, then click the square that appears and choose format only.

Best regards,
Trowa

Conditional formatting with Excel

1 response

Similar discussions

Subscribe To Our Newsletter!