View Single Post
 
Old 11-30-2011, 08:17 AM
NEHicks503 NEHicks503 is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2010
Posts: 4
NEHicks503 is on a distinguished road
Unhappy conditional formatting formula

I need to use conditional formatting to highlight certain cells. Example:

Column A ........................Column B
1 Due Date .....................Completion date
2 Due Date ......................Blank

I need to highlight A2 if B2 is blank.

I can format it to highlight Column A cells that fall within a date range, but I haven't come up with a formula that will highlight cells in Column A if the corresponding cell in Column B is empty. Any help would be appreciated.
Reply With Quote