Setting Conditional Formatting

J

jacky.newsgroup

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?
 
B

Bob Phillips

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)
 
H

Hans Knudsen

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

Hans
 
M

macropod

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
 
J

jacky.newsgroup

Hi Macropad,

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

Thanks! :)~
 
Top