CODEWITHSUNDEEP
excelconditional-formatting
Gideon
Gideon

Reputation: 53

excel conditional formatting: highlight the rest of a row after a certain character is entered into a cell

I have a row containing 35 or so cells. I would like to be able to conditionally format all cells to the right of a certain character - ie #.

'#' can be added at any point in the row.

Cells to the left of the # will retain other existing conditional formatting rules and not be overwritten.

Data validation exists on all cells.

the nearest I can get is the answer here Conditional Formatting Entire Row If Any Cell Contains the Specified Text

but this highlights the entire row - and overwrites conditional formatting in the row prior to the #.

My sheet contains 75 rows that I need to behave like this (independently of course).

Can anyone help please? Many thanks!

Upvotes: 0

Views: 192

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

Assuming your columns are A through AI.

Set all the columns for the rule and use the following formula:

=COUNTIF($A1:A1,"#")>0

Then choose the fill you want.

enter image description here

Upvotes: 2

Related Questions