software

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

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)

quot;aMackquot; gt; wrote in message
...
gt; I need to set a condition for formatting cell F5 based on the value of
cell
gt; E6. ow do I do this?
gt;
gt; Thanks
gt; --
gt; A MACKENZIE, CMA, MBA
Thanks.

Now if the value needs to be quot;NULLquot; or Blank - what is the value?

--
A MACKENZIE, CMA, MBAquot;Bob Phillipsquot; wrote:

gt; Use conditional formatting, change the condition to formula is and a formula
gt; of =$E$6=value
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;aMackquot; gt; wrote in message
gt; ...
gt; gt; I need to set a condition for formatting cell F5 based on the value of
gt; cell
gt; gt; E6. ow do I do this?
gt; gt;
gt; gt; Thanks
gt; gt; --
gt; gt; A MACKENZIE, CMA, MBA
gt;
gt;
gt;

=$E$6=quot;quot;

or

=LEN($E$6)=0

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;aMackquot; gt; wrote in message
...
gt; Thanks.
gt;
gt; Now if the value needs to be quot;NULLquot; or Blank - what is the value?
gt;
gt; --
gt; A MACKENZIE, CMA, MBA
gt;
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Use conditional formatting, change the condition to formula is and a
formula
gt; gt; of =$E$6=value
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;aMackquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I need to set a condition for formatting cell F5 based on the value of
gt; gt; cell
gt; gt; gt; E6. ow do I do this?
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt; --
gt; gt; gt; A MACKENZIE, CMA, MBA
gt; gt;
gt; gt;
gt; gt;
YESSSSSS!!!!!!
--
A MACKENZIE, CMA, MBAquot;Bob Phillipsquot; wrote:

gt; =$E$6=quot;quot;
gt;
gt; or
gt;
gt; =LEN($E$6)=0
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;aMackquot; gt; wrote in message
gt; ...
gt; gt; Thanks.
gt; gt;
gt; gt; Now if the value needs to be quot;NULLquot; or Blank - what is the value?
gt; gt;
gt; gt; --
gt; gt; A MACKENZIE, CMA, MBA
gt; gt;
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt; gt; Use conditional formatting, change the condition to formula is and a
gt; formula
gt; gt; gt; of =$E$6=value
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; Bob Phillips
gt; gt; gt;
gt; gt; gt; (remove nothere from email address if mailing direct)
gt; gt; gt;
gt; gt; gt; quot;aMackquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; I need to set a condition for formatting cell F5 based on the value of
gt; gt; gt; cell
gt; gt; gt; gt; E6. ow do I do this?
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks
gt; gt; gt; gt; --
gt; gt; gt; gt; A MACKENZIE, CMA, MBA
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;