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
Hi Agus,
I made a sheet look like this:
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
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