Conditional formatting

[gaevynne]

Hello,

i want to highlight in red the due dates but only if they are pending on the status. If it's Posted it should stay as is. Can someone help me on how to conditional format this?
Thank you.

[TABLE="width: 434"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Status[/TD]
[TD]Date Received[/TD]
[TD]Due Date[/TD]
[/TR]
[TR]
[TD]Posted[/TD]
[TD]21-Aug[/TD]
[TD]5-Sep[/TD]
[/TR]
[TR]
[TD]Posted[/TD]
[TD]29-Aug[/TD]
[TD]13-Sep[/TD]
[/TR]
[TR]
[TD]Pending[/TD]
[TD]13-Sep[/TD]
[TD]27-Sep[/TD]
[/TR]
[TR]
[TD]Posted[/TD]
[TD]2-Oct[/TD]
[TD]17-Oct[/TD]
[/TR]
[TR]
[TD]Pending[/TD]
[TD]2-Oct[/TD]
[TD]17-Oct[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Re: Can someone help me on how to conditional format this?

Let's say that your Statuses are in column A and Due Date is in column C.
Then, select column C, and enter this Conditional Formatting formula:

=$A1="Pending"

and choose your red color.

 

[Marcelo Branco]

Re: Can someone help me on how to conditional format this?

Select C2:C6 being C2 the active cell

In Conditional Formatting pick the formula option and insert this formula
=$A2="Pending"
pick the format you want

M.

 

[gaevynne]

Re: Can someone help me on how to conditional format this?

Hi Thanks for the replies. I would like to rephrase my question. How do i conditional highlight the date if it's already due for example. the due date is Oct. 18, 2017. I would like to highlight the cell in red if the date passed one day like if the date today is 19 it should trigger a conditional format. Thanks again.

 

[Joe4]

Re: Can someone help me on how to conditional format this?

So, if the Due Date is in Column C, they to highlight whatever cell in row 2 based on the date in cell C2, use the CF formula:

=$C2 < TODAY()

This say to highlight it if the date in cell C2 is less than (before) today's date.

 

[gaevynne]

Re: Can someone help me on how to conditional format this?

Hi Thanks for the replies. I would like to rephrase my question. How do i conditional highlight the date if it's already due for example. the due date is Oct. 18, 2017. I would like to highlight the cell in red if the date passed one day like if the date today is 19 it should trigger a conditional format. Thanks again.

Sorry i only need to highlight the date due if it's pending...if it's "posted" even if it's due it should not be highlighted as posted means done. thx

 

[Joe4]

Re: Can someone help me on how to conditional format this?

So it sounds like you need/want to combine your two conditions. Just use AND to do that, i.e.

=AND($A2="Pending",$C2 < TODAY())

 

[gaevynne]

Re: Can someone help me on how to conditional format this?

So it sounds like you need/want to combine your two conditions. Just use AND to do that, i.e.

=AND($A2="Pending",$C2 < TODAY())

Thank you so much this is perfect!

 

[Joe4]

Re: Can someone help me on how to conditional format this?

You are welcome.