Date in excel

helpimcrap · 24 Jun 2009 at 15:43

quick question...

how do i conditionally format a cell to highlight itself a different colour if the date entered is within 30 days of todays date?

tres · 24 Jun 2009 at 15:48

=if(A1>TODAY()+28,1,0)

div0 · 24 Jun 2009 at 15:54

What's with all the Excel questions in GD just now?

xxalxx · 24 Jun 2009 at 15:59

div0 said:
What's with all the Excel questions in GD just now?

maybe excel has reached the general masses

helpimcrap · 24 Jun 2009 at 16:01

div0 said:
What's with all the Excel questions in GD just now?

i was browsing there and noticed it so i asked. didn't realise there was a seperate section otherwise i'd have looked lol.

cheers tres.

tres · 24 Jun 2009 at 16:12

you're welcome!