Forum Discussion
Solved
Change the cell color base on IF value
Hi Expert
How can I create an excel formula for below condition
Condition
| Day | Unit |
| Sunday | 10 |
| Monday | 20 |
| Tuesday | 30 |
| Wednesday | 40 |
| Thursday | 50 |
| Friday | 60 |
| Saturday | 70 |
If condition is below above value, the cell should change to red color
| Day | Condition is meet or not |
| Sunday | 30 |
| Tuesday | 15 (This cell should change to red color) |
| Monday | 40 |
| Friday | 40 (This cell should change to red color) |
| Wednesday | 80 |
| Monday | 5 (This cell should change to red color) |
| Saturday | 60 (This cell should change to red color) |
| Friday | 80 |
| Wednesday | 55 |
anwarsafian added the following CF rule to your file.
=B13<XLOOKUP(A13,$A$3:$A$9,$B$3:$B$9)See attached. If you have an older version of Excel you can achieve something similar with VLOOKUP. That would be:
=B13<VLOOKUP(A13,$A$3:$B$9,2,0)
1 Reply
anwarsafian added the following CF rule to your file.
=B13<XLOOKUP(A13,$A$3:$A$9,$B$3:$B$9)See attached. If you have an older version of Excel you can achieve something similar with VLOOKUP. That would be:
=B13<VLOOKUP(A13,$A$3:$B$9,2,0)