Please Help With This Formula

[p3project]

In column D I have a category rating 1, 2, 3 or 4 for example cat
means a repair must be made within one month, cat 2 within 3 month
etc. Column J is date issued, column K is date due.

My question is - how can I flag what is overdue? Can a cell turn into
colour via a formula on a certain date??

I would be very grateful for any ideas

Regards

Dav

 

[Andy B]

Hi

Have a look at Conditional Formatting (Format / Conditional Formatting)
Visit here too:
http://www.contextures.com/xlCondFormat01.html
for an introduction

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format'. In your case
you could select cell K1 and enter the following formula
in the conditional format dialog
=K1>TODAY()

also see
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html