Excel 2007 : Conditional Formatting- Mixed Data

**DGagnon** · 03-23-2012, 02:44 PM

try editing your conditional format formula to this:

=AND(I2<>"approved- no change",J2-14<TODAY(),J2<>"")

i think it is working based on the decription you provided.

note: the data you provided has no lines that should be highlighted based on this formula

**needyohelp** · 03-23-2012, 03:03 PM

Originally Posted by DGagnon

=AND(A2<>"approved",B2-14<TODAY(),B4<>"")

and the star is to the bottom right just bellow the post, its a 6 pointed star. feel free to 'rep' any members who contributed positivly to your thread.

I've input a test area that contains cells with relevant dates. The approved cell doesnt seem to have an effect. data.xlsx