View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Conditional formatting of dates in two cells using Excel 2007

Select cell A2
Select conditional format - formula
Enter the following forumla
=AND(B2<TODAY(),C2="")
Set the required format then OK/apply etc until exit conditional format
Copy Cell A2
Paste Special - Formats to the remaining cells to have the conditional
format.

In lieu of copy - paste special you can also select the entire range to
format before opening conditional format just so long as you ensure that A2
is the active cell (The first cell in the selection or one that stays white
in the selection). You then enter the formula as if only applying it to only
one cell A2 exactly as above.

--
Regards,

OssieMac