Change the cell color base on IF value

[anwarsafian]

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

[#2 · Accepted solution]

@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)