Contional Formatting - other cells
 

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

Thanks
--
A MACKENZIE, CMA, MBA

Contional Formatting - other cells
 

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" wrote in message
...
I need to set a condition for formatting cell F5 based on the value of
cell
E6. ow do I do this?

Thanks
--
A MACKENZIE, CMA, MBA

Contional Formatting - other cells
 

Thanks.

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

--
A MACKENZIE, CMA, MBA


"Bob Phillips" wrote:

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" wrote in message
...
I need to set a condition for formatting cell F5 based on the value of
cell
E6. ow do I do this?

Thanks
--
A MACKENZIE, CMA, MBA

Contional Formatting - other cells
 

=$E$6=""

or

=LEN($E$6)=0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"aMack" wrote in message
...
Thanks.

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

--
A MACKENZIE, CMA, MBA


"Bob Phillips" wrote:

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" wrote in message
...
I need to set a condition for formatting cell F5 based on the value of
cell
E6. ow do I do this?

Thanks
--
A MACKENZIE, CMA, MBA

Contional Formatting - other cells
 

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


"Bob Phillips" wrote:

=$E$6=""

or

=LEN($E$6)=0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"aMack" wrote in message
...
Thanks.

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

--
A MACKENZIE, CMA, MBA


"Bob Phillips" wrote:

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" wrote in message
...
I need to set a condition for formatting cell F5 based on the value of
cell
E6. ow do I do this?

Thanks
--
A MACKENZIE, CMA, MBA