Highlighting a Row using a conditional format

T

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
 
J

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
 
Top