Dear Experts,

I've quickly scanned this forum and searched the Excel help but to no
avail...could you please assist me?

I have an IF formula as follows:

=IF(G2<=D21,"OVERDUE","OK")

I want the results (either OVERDUE or OK) to be displayed in different
colours - OVERDUE in red and OK in green. I've tried using the [red] and
[green] tags but in the formula it mistakes them for the true/false
statements.

Is there a way to do this?

(FYI, the IF formula is based on dates...I don't know if this is relevant
but the spreadsheet is to show whether or not recurring work/tasks are
overdue and are based on when they were last completed, add on however many
months before the next one is due and then this IF formula reflects the
status of those tasks).

Regards,
Kylii