Conditional formatting to show "Overdue" if date in adjacent cell is older than 5 days

Hi all

I need help!

I have this formula =IF(AND(LEFT(A3,3)="OIL",H3+5< TODAY(),H3<>""),"Overdue","") and I want to do the same but using conditional formatting instead, is it even possible? I've tried many different variations but have not found a solution.

This works fine, but as its a formula in a cell, on a spreadsheet used by multiple users it keeps getting deleted and I am trying to find a workaround.

I'd rather not use VBA but if conditional formatting is not an option then I am open to any and all suggestions.

Thanks for looking and any help is greatly appreciated.

Stuart

Select the column which u want to highlight RED or other color with first selected cell of column be from 3rd row and then paste your if condition in the conditional formatting setting when formula is as below. Also set the type of formatting you want to apply.

=AND(LEFT(A3,3)="OIL",H3+5< TODAY(),H3<>"")

Hope this helps...

Heroceebee

Many thanks Stileicon, not exactly what I needed but pointed me in the right direction to find a solution. Much appreciated.

Thanks for your appreciations Stuart