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!
0
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
0