Conditional formatting

Closed
Veronique - Aug 27, 2018 at 02:03 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Aug 28, 2018 at 12:23 PM
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 responses

Blocked Profile
Aug 27, 2018 at 04:47 PM
So what is the issue? Highlight EVERY CELL on the sheet, and apply the formula! Try that!
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Aug 28, 2018 at 12:23 PM
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