Conditional formatting

Veronique - Aug 27, 2018 at 02:03 PM - Latest reply: TrowaD
Posts
2445
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2018
- 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
See more 

Your reply

2 replies

ac3mark
Posts
10830
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 13, 2018
- Aug 27, 2018 at 04:47 PM
0
Thank you
So what is the issue? Highlight EVERY CELL on the sheet, and apply the formula! Try that!
Respond to ac3mark
TrowaD
Posts
2445
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 12, 2018
- Aug 28, 2018 at 12:23 PM
0
Thank you
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
Respond to TrowaD