Date from / to colour change

Good afternoon

I am brand new to your forum, so apologise if i repeat any threads !

I am looking to have cells change colour when a date hits 14 days after stock has been taken in.

I realise there was a thread on here already but i think it applied to 1 date.

What i'm trying to do is a 'date in' and a 'date out' for warehousing cost purposes. When the date out is manually entered and is over 14 days from date in, i want it to show red.

I hope this isn't goggledegook and would appreciate any help

Conditional formatting will work for this one.



Format the date out cell to show red if its greater than or equal to input cell +14

Thanks very much for the quick response but i am not up to speed with 'conditional formatting', would you be able to give me a step by step please ?

Thanks in advance

Brilliant, that works ! How do i get it to work for the whole worksheet though ?

Sorry about this ?

Done, thanks very much