Forum Discussion
anwarsafian
Jul 22, 2024Copper Contributor
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)
- Riny_van_EekelenPlatinum Contributor
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)