Conditional formatting question.

[Bobster]

Hi. I have a table with many columns of items. These columns have been given an "importance" score. I want to highlight dates with in each column that go out of date dependent on the "importance" score.

E.g column 3,4,6 all score an A grade for importance whilst 2,5,7,8 and 9 score a B. I want data in those columns rated A to turn red if 1 year old and B if 2 years old.

Thanks.

[brant.wheeler]

This would be much easier if you posted a sample workbook.

[Bobster]

Hi im trying to work out the conditional formatting to get a table (at least 18 times the size of this)
Importance score A A B A C A B B B B
basic skills 1 essential learning needed course 1 essential skills 2 desired course 1 basic skills 2 needed course 3 important course 1 imporant course 2 basics skills 3
Bob 12/03/2017 13/03/2017 14/03/2017 15/03/2017 16/03/2017 17/03/2017 18/03/2017 19/03/2017 20/03/2017 21/03/2017
Ben 24/03/2019 25/03/2019 26/03/2019 27/03/2019 28/03/2019 29/03/2019 30/03/2019 31/03/2019 01/04/2019 02/04/2019
Dolly 23/05/2016 24/05/2016 25/05/2016 26/05/2016 27/05/2016 28/05/2016 29/05/2016 30/05/2016 23/05/2016 23/05/2016
Edith 15/09/2018 16/09/2018 17/09/2018 18/09/2018 19/09/2018 20/09/2018 21/09/2018 22/09/2018 15/09/2018 15/09/2018
Ken 15/09/2018 16/09/2018 17/09/2018 18/09/2018 19/09/2018 20/09/2018 21/09/2018 22/09/2018 23/09/2018 24/09/2018
Charlie 30/07/2018 31/07/2018 01/08/2018 02/08/2018 03/08/2018 04/08/2018 05/08/2018 06/08/2018 07/08/2018 08/08/2018
Keith 05/01/2019 06/01/2019 07/01/2019 08/01/2019 09/01/2019 10/01/2019 11/01/2019 12/01/2019 13/01/2019 14/01/2019
Ethil 06/02/2018 07/02/2018 08/02/2018 09/02/2018 10/02/2018 11/02/2018 12/02/2018 13/02/2018 14/02/2018 15/02/2018


formated to highlight dates that are a different time for each importance score. so for Courses that are

A - they need to be done yearly so if over a year old I want to turn Red,
B - they need to be done 2 yearly then turn red if over that
C - 3 yearly and so on.

I tried to up load images and books but nothing was working and cut and pace seems to have failed me too!

Many thanks for your help.

B

[Sam Capricci]

in columns where you want 1 year or longer try this conditional formatting (CF) =C2+365< TODAY() and format cell fill as red, you may have to reopen it to remove any " that might appear around the formula.
In columns with 2 years or longer try this... =B2+730< TODAY()
then for both you can use the format painter (paint brush) to spread it across the columns you want those to apply to.
and do similar for 3 years "and so on."

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.