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?