View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Guest3731 Guest3731 is offline
external usenet poster
 
Posts: 4
Default conditional formatting for "overdue" status

Hi, a conditional formatting question. I've got a task list. Two
columns are relevant.

Column A - "Due Date"
Column B - "Complete?"

Column A is in date format, Column B just has an "x" in it if the task
is complete.

What I want is for the date in Column A to show up in red type if the
"Due Date" is "greater than" today's date, and at the same time
there's no "x" in the corresponding entry in Column B.

Is this doable? I see how to do basic conditional formatting, but I
don't see how to tie in values from different columns/cells. Thanks.