software

hi,

how do i setup conditional formatting to reflect the following:
- when cell is blank, change into red background

i know how to setup quot;change into red backgroundquot;

but how do u specify when the cell is blank?Change the condition to 'equal to' and the value to quot;quot;. Note I find that I
have to go back and change it from =quot;quot;quot;quot;quot;quot; which Excel does, to =quot;quot;.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

gt; wrote in message oups.com...
gt; hi,
gt;
gt; how do i setup conditional formatting to reflect the following:
gt; - when cell is blank, change into red background
gt;
gt; i know how to setup quot;change into red backgroundquot;
gt;
gt; but how do u specify when the cell is blank?
gt;
Hi
Format, Conditional Formatting, Condition 1: Formula Is.
In the field to the right, enter: =ISBLANK(A1).

Hansgt; skrev i en meddelelse oups.com...
gt; hi,
gt;
gt; how do i setup conditional formatting to reflect the following:
gt; - when cell is blank, change into red background
gt;
gt; i know how to setup quot;change into red backgroundquot;
gt;
gt; but how do u specify when the cell is blank?
gt;
Hi Jacky,

That depends on what you mean by 'blank'. Is it cells that simply appear
blank (eg they could have formulae returning quot;quot;, or perhaps spaces entered
by users, or even zeros suppressed via Tools|Options|View), or is it cells
with absolutely nothing in them?

For the former, excluding suppressed zeros :
=LEN(TRIM(A1))=0,
For the former, including suppressed zeros :
=OR(LEN(TRIM(A1))=0,A1=0)
For the latter:
=ISBLANK(A1)

Cheersgt; wrote in message oups.com...
gt; hi,
gt;
gt; how do i setup conditional formatting to reflect the following:
gt; - when cell is blank, change into red background
gt;
gt; i know how to setup quot;change into red backgroundquot;
gt;
gt; but how do u specify when the cell is blank?
gt;
thanks guys!!

i was trying to put, =NULL, haha~ Hi Macropad,

you're right! It contains formulae (appeared blank)!

Thanks! ~