Setting Conditional Formatting
 

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?

Setting Conditional Formatting
 

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?

Setting Conditional Formatting
 

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?

Setting Conditional Formatting
 

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?

Setting Conditional Formatting
 

thanks guys!!

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

Setting Conditional Formatting
 

Hi Macropad,

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

Thanks! :)~