Conditional formatting [Closed]

Report
-
Posts
2660
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 29, 2020
-
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

Last Name First name Position Step New Position New Step
Smith Paul 999111 4 999999
Walter Val 999787 3 4
Simons Paul 963633 2
McGruters Laura 963621 1 952412

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

2 replies


So what is the issue? Highlight EVERY CELL on the sheet, and apply the formula! Try that!
Posts
2660
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 29, 2020
442
Hi Veronique,

Don't change the formula, just the applied to range.
Change:
$A$2:$F$2
Into:
$A$2:$F$3
Or to any number of rows you want the CF applied to.

Best regards,
Trowa