Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi
Try this: =IF(B1<"",AND(C1="Completed")) rinse and repeat for all your other cells. HTH Mick. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting Formula using AND | Excel Worksheet Functions | |||
conditional formatting formula | Excel Programming | |||
Conditional Formatting formula | Excel Discussion (Misc queries) | |||
Conditional Formatting: Formula is | Excel Worksheet Functions | |||
conditional formatting with FORMULA... Please HELP! | Excel Discussion (Misc queries) |