Change the cell color base on IF value

/ 2024-07-22 / Microsoft

Hi Expert

How can I create an excel formula for below condition

Condition

DayUnitSunday10Monday20Tuesday30Wednesday40Thursday50Friday60Saturday70

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

DayCondition is meet or notSunday30Tuesday15 (This cell should change to red color)Monday40Friday40 (This cell should change to red color)Wednesday80Monday5 (This cell should change to red color)Saturday60 (This cell should change to red color)Friday80Wednesday55

Hi Expert How can I create an excel formula for below condition ConditionDayUnitSunday10Monday20Tuesday30Wednesday40Thursday50Friday60Saturday70 If condition is below above value, the cell should change to red color DayCondition is meet or notSunday30Tuesday15 (This cell should change to red color)Monday40Friday40 (This cell should change to red color)Wednesday80Monday5 (This cell should change to red color)Saturday60 (This cell should change to red color)Friday80Wednesday55 Read More

Tags: microsoft