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


--
Wei
------------------------------------------------------------------------
Wei's Profile: http://www.excelforum.com/member.php...o&userid=24590
View this thread: http://www.excelforum.com/showthread...hreadid=381834

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


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=381834

Hi!

Assume the cell in question is A1.

Select cell A1
Goto FormatConditional 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

"Wei" wrote in message
...

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


--
Wei
------------------------------------------------------------------------
Wei's Profile:
http://www.excelforum.com/member.php...o&userid=24590
View this thread: http://www.excelforum.com/showthread...hreadid=381834

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

"Wei" wrote in message
...

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