I need to format a cell so that if it stays blank, the cell is red.
J JE McGimpsey Jul 11, 2005 #2 One way: Format/Conditional Formatting... CF1: Formula is =ISBLANK(A1) Format1: Pattern/Red
A Anne Troy Jul 11, 2005 #3 What do you mean "so it stays blank". If you want it to APPEAR blank, make the font match the fill (red). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
What do you mean "so it stays blank". If you want it to APPEAR blank, make the font match the fill (red). ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com
B Bill R Aug 13, 2005 #4 Use: IF(ISBLANK,(INPUT THE ADDRESS OF CELL),"",PUT THE DESIRED RESULT HERE.)
