Conditional formatting

Veronique - Aug 27, 2018 at 02:03 PM - Latest reply: TrowaD 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen
- 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 10503 Posts Monday June 3, 2013Registration dateModeratorStatus September 19, 2018 Last seen - 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 2433 Posts Sunday September 12, 2010Registration dateModeratorStatus September 17, 2018 Last seen - 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