Contional Formatting - other cells

[aMack]

I need to set a condition for formatting cell F5 based on the value of cell
E6. ow do I do this?

Thanks

 

[Bob Phillips]

Use conditional formatting, change the condition to formula is and a formula
of =$E$6=value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[aMack]

Thanks.

Now if the value needs to be "NULL" or Blank - what is the value?

 

[Bob Phillips]

=$E$6=""

or

=LEN($E$6)=0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[aMack]

YESSSSSS!!!!!!
--
A MACKENZIE, CMA, MBA

=$E$6=""

or

=LEN($E$6)=0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)