Highlighting a Row using a conditional format

[tim]

Hi all,

Is there a way to conditional format a cell so that when a particular
text is input it will highlight the row the cell is in to a color of
choice?

Thanks so much


Tim

 

[JulieD]

Hi Tim

yes

assume that column B contains the information you want to test against your
criteria and your data is in the range A1:G100

select A1:G100, choose format / conditional formatting
choose
formula is
and type =$B1="yes"
or whatever your criteria is
set the format

let us know how you go

Cheers
JulieD

 

[tim]

Hi JulieD

That worked perfectly, thank you so much!

Tim

 

[JulieD]

Glad to assist

Hi JulieD

That worked perfectly, thank you so much!

Tim