someone must how to do this. :):)

W

Wei

hi, everyone. i wanna know what function should i use if I want a cell'
backgroud to appear red when there is no data in the cell, but as soo
as something is inserted, the backgound colour returns to the norma
white. Thank you. :
 
D

duane

if the cell in question is cell A1

use conditional formating, with the formula
=isblank(a1)=true and select red

copy this cell as required
 
B

Biff

Hi!

Assume the cell in question is A1.

Select cell A1
Goto Format>Conditional Formatting
Select from the drop down list: Formula is
Enter this formula in the box:

=A1=""

Click the Format button
Select the Pattern tab
Select the color of your choice
OK out

Biff
 
L

Lewis Clark

If the cell of interest is A1, click on cell A1. Then click on FORMAT, then
CONDITIONAL FORMATTING.
Set condition 1 to "formula is". Then in the formula field type
"=isblank(a1)". Then click on the format button and choose the format you
want (pattern .. red in this case).
 
Top