Highlighting a Row using a conditional format

  • Thread starter Thread starter tim
  • Start date Start date
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
 
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
 
Back
Top