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