Conditional formatting based on date in one row, text in another

[akg742]

I am having trouble coming up with a formula to turn a cell in column A red if the date in column B is older than 30 days and column H is not "cancelled" or "closed". I'm using the formula below to count how many rows fit that criteria but I can't seem to translate it to the conditional formatting format

=COUNTIFS(H:H,"<>c*",B:B,"<"&TODAY()-30)

 

[Joe4]

Something like this?

If so, select range A2:A7, go to Conditional Formatting, select the "Use a formula to determine which cells to format", and enter this formula:

=AND(TODAY()-$B2>30,$H2<>"Cancelled",$H2<>"Closed")

Then choose the Red fill formatting option and press OK.

 

[akg742]

Thank you! This worked perfectly.

Something like this?
View attachment 119238

If so, select range A2:A7, go to Conditional Formatting, select the "Use a formula to determine which cells to format", and enter this formula:

=AND(TODAY()-$B2>30,$H2<>"Cancelled",$H2<>"Closed")

Then choose the Red fill formatting option and press OK.

 

[Joe4]

You are welcome.
Glad I was able to help!