Conditionally Formatting a Row

[Calibre16]

Hello,

I want to conditionally format an entire row, only if one of the cells contains the word issue.

e.g. - cells A2:I2 to conditionally format to orange if cell C2 = Issue

Help appreciated

Cal

 

[Momentman]

If you want it to apply to rows 1 to 20, then highlight rows 2 to 20 and use a formula like
=$A1="issue" and select the formatting options

 

[Calibre16]

Thank you kindly Moment Man

 

[Momentman]

Thank you kindly Moment Man

I assume it worked?

I actually meant highlight rows 1 to 20 not 2 to 20