Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change colour of cell if there is no value
Select the desired range, say B2:D10 (with B2 active)
Click Format Conditional Formatting Under Condition 1, make it as Formula is:=B2="" Format Pattern Light green? OK Click OK at the main dialog (Above assumes B2:D10 contains no "normal" fill color) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Jennifer1960" wrote: Using selected cells only (some already contain a IF statement or data) I want to have cells change colour if there is no value or data in it. That is if data or value is then entered it would revert back to no fill. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alternating cell colour | New Users to Excel | |||
Conditional Format as a MACRO | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |