Conditional formatting with Excel
Closed
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
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
Related:
- Conditional formatting with Excel
- Excel mod apk for pc - Download - Spreadsheets
- How to change date format in excel - Guide
- Marksheet format in excel - Guide
- How to clear formatting in excel - Guide
- Gif in excel - Guide
1 response
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
