ExcelBanter - conditional formatting for "overdue" status

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - conditional formatting for "overdue" status (https://www.excelbanter.com/excel-discussion-misc-queries/185527-conditional-formatting-overdue-status.html)

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.

conditional formatting for "overdue" status

Try =AND(A2NOW(),B2<"x")

HTH

"Guest3731" wrote:

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.