Conditional formatting

Closed
Veronique - 27 Aug 2018 à 14:03
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 28 Aug 2018 à 12:23
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
27 Aug 2018 à 16:47
So what is the issue? Highlight EVERY CELL on the sheet, and apply the formula! Try that!
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
28 Aug 2018 à 12:23
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