Excel conditional formatting

Question

I have a training matrix containing dates of expiry for each training discipline. I want to use a colour code of green for current or in date, Amber for expires in 14 days and Red for expired. How do I do it. Idiots guide please.

Thanks in advance

Answer 1

Hi Steve

Please share the link to the file you uploaded

If you need help about how to do it please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

Answer 2

Hey Sukie,

Thank you so much. I have uploaded the file if you could take a look. 

Cheers

Steve

Answer 3

Idiots guide please.

Okay, I'll do my best. :-)

At first, have a look here:

https://www.microsoft.com/en-us/microsoft-365/blog/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/

If you need further:

Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).

Click Upload in the top and choose your file.

After uploading, right click the file and choose share.

Click Get a Link.

Copy the link and paste it here.

Andreas.

 Thank you Andreas,

Much appreciated,  I have uploaded the file as suggested.

Steve

Answer 4

Hi Steve59April,

Thank you for querying in this forum.

According to your description, it seems that you have a column with date, and you want to format the date as green if it shows the current date, and if it will expire in 14 days and it shows Amber, and it shows red if it is expired.

May I know if my understanding is right? If so, you can refer to the formula below:

 

 

 

If the scenario above is not consistent with yours, you can also refer to the suggestion Andreas provided to share your file via OneDrive, and we will focus on your specific scenario and provide specific suggestions.

Best Regards,

Sukie

Answer 5

Idiots guide please.

Okay, I'll do my best. :-)

At first, have a look here:

https://www.microsoft.com/en-us/microsoft-365/blog/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/

If you need further:

Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).

Click Upload in the top and choose your file.

After uploading, right click the file and choose share.

Click Get a Link.

Copy the link and paste it here.

Andreas.