Alerts

Please help, I'm putting in due dates into excel and I'd like the cells to change colours when the cells get within two days and also when it's overdue. Also, is it possible that when the adjoining cell has been filled in (as in task completed) is it possible to over rule the formatting on date cells so they appear green?

I should mention that I'm a relative newbie so basic language would be appreciated!

Thanks!

if your dates are in column A then highlight column A and go conditional format / formula is and enter the following formulas

Please Login or Register  to view this content.

and format your colour to turn if date entered in B1 then add condition 2

Please Login or Register  to view this content.

and format your colour to change when 2 days out then add condition 3

Please Login or Register  to view this content.

and format your colour for past due

Hey cheers for that, once I'm in "conditional formatting", "new rule" what settings do I need to set prior to entering the above settings?
ie: selcting a rule type and editing rule description?

Thanks!