hi,

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

i know how to setup "change into red background"

but how do u specify when the cell is blank?

Change the condition to 'equal to' and the value to "". Note I find that I
have to go back and change it from ="""""" which Excel does, to ="".

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
hi,

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

i know how to setup "change into red background"

but how do u specify when the cell is blank?

Hi Jacky,

That depends on what you mean by 'blank'. Is it cells that simply appear
blank (eg they could have formulae returning "", 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)

Cheers


wrote in message
oups.com...
hi,

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

i know how to setup "change into red background"

but how do u specify when the cell is blank?

Hi Macropad,

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

Thanks! :)~

Hi
Format, Conditional Formatting, Condition 1: Formula Is.
In the field to the right, enter: =ISBLANK(A1).

Hans


skrev i en meddelelse oups.com...
hi,

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

i know how to setup "change into red background"

but how do u specify when the cell is blank?

thanks guys!!

i was trying to put, =NULL, haha~ :)