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?