Forum Discussion

anwarsafian's avatar
anwarsafian
Copper Contributor
Jul 22, 2024

Change the cell color base on IF value

Hi Expert

 

How can I create an excel formula for below condition

 

Condition

DayUnit
Sunday10
Monday20
Tuesday30
Wednesday40
Thursday50
Friday60
Saturday70

 

If condition is below above value, the cell should change to red color

 

DayCondition is meet or not
Sunday30
Tuesday15 (This cell should change to red color)
Monday40
Friday40 (This cell should change to red color)
Wednesday80
Monday5 (This cell should change to red color)
Saturday60 (This cell should change to red color)
Friday80
Wednesday55

 

 

Resources