Conditional formatting - formula=text

Hey all,

I am trying to set some conditional formatting, but for some reason on of the conditions is not working and I was wondering if anybody know how -

Please Login or Register  to view this content.

Basically, the cell should go Red if the date in it is blank, is over 7 days ago, is in the future or contains the text 'File does not exist'. The first three conditions work fine but the when the cell contains the text 'File does not exist' no conditional formatting is applied at all. I have copied the text from the workbook into the conditional format to ensure that it is correct.

Thanks.

Hey,

Thanks for the reply. That works in exactly the same way as before, where by the first 3 conditions work but the final one ($D22="File does not exist") does not.

Thanks.

Yes, I realized that after and deleted the post,

Try:

=IF($D22="File does not exist",TRUE,OR($D22="",TODAY()-$D22>=7,$D22>TODAY()))

Superb, thanks for that.