Hi,

I am looking for some help with a spreadsheet that we are using to highlight certificate expiry dates for suppliers.

I am looking for a specific cell (use A1) to change colour and produce a specific text when a year after a date is reached in another cell (Use A2).

I want A1 to stay green and say 'ok' until a year after the date in A2 and then once it is year after the date in A2, A1 should turn to red and say 'Expired'.

can anyone help please?