Hello, I want to change the font color for lines that have been updated. If a new position or new step is entered, the font colour of the entire row should be changed in orange. Column E > conditional formatting > manage rules > New rule > Use a formula to determine which cells to format Formula =IF(NOT(ISBLANK($E2)),TRUE) Format = Bold orange color Applies to : =$A$2:$F$2 How to replicate it to the following rows? The formula does replicate but not the Applies to For row 3 I should get Formula =IF(NOT(ISBLANK($E3)),TRUE) Format = Bold orange color Applies to : =$A$3:$F$3 Thank you
Solved by I. A. in 12 mins