Related:

- Conditional formatting with Excel
- Excel date format dd.mm.yyyy - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Screenshot in excel - Guide

## 1 reply

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