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?