RE: Conditional Formatting; IF Functions

Hello Christopher,

Hope you enjoyed your Microsoft Excel course with Best STL.

Thank you for your question regarding Conditional Formatting and IF functions.

You haven't given much information regarding how many date fields you have in the sheet, however, I assume you are comparing one date with either another date to establish the overdue position.

If this is the case simply select the column of dates where you require the conditional formatting to appear, then click 'Format' 'Conditional Formatting' click the top left drop-down and select 'Formula Is'.

Type the formula into the field area to the left and then click the 'Format' button and choose font/fill colours as required. Then click OK.

A typical formula could be =latest date field - older date field > time limit in days e.g. (=(E2-A2)>15)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer