Colour cell/conditional formatting

[Webslinger83]

Hi just wondering if anyone has an easy solution to this, I’m an enthusiastic amateur in excel! I have set up a formula based on a date and date range ie if set date is 0-4 years post todays date then cell = A if 4-8 years post todays date then cell = B etc I want to put some conditional formatting on the cells so that if a cell changes from A to B due to date then the cell becomes highlighted in dealing with a lot of rows of data and would rather not scroll through the entire sheet to check for changes if it can be easily highlighted. Is this something that can be done if so how do I go about doing it?

Thank you in advance of any help provided

 

[awoohaw]

Welcome to the forum. Can you post a few rows of your data, using the xl2bb or cut and paste of the cells? (xl2bb link is below or in the post formatting/editing bar)

 

[Webslinger83]

Welcome to the forum. Can you post a few rows of your data, using the xl2bb or cut and paste of the cells? (xl2bb link is below or in the post formatting/editing bar)

Hi sorry for delay had to start up on my own laptop as I dont have downlad permissions on my work laptop

Grades.xlsx
	A	B	C	D
1	Name	Sol, CILEX or Other	Date	Grade
2	A Smith	Sol	15/01/1992	A
3	B Smith	Sol	01/01/2019	B
4	C Smith	Sol	01/11/2018	B
5	D Smith	Sol	01/04/2017	B
6	E Smith	Other		D
7	F Smith	Other		D
8	G Smith	Other		D
9	H Smith	Other		D
10	I Smith	Sol	01/09/1987	A
11	J Smith	Sol	01/06/2010	A
12	K Smith	Other		D
13	L Smith	Other		D
14	M Smith	Sol	01/07/2022	C
15	N Smith	Sol	01/11/2015	A
16	O Smith	Sol	01/10/2018	B
17	P Smith	Sol	01/10/2020	C
18	Q Smith	CILEX	01/10/2020	C
19
20
Sheet1

Cell Formulas
Range	Formula
D2:D18	D2	=IF(ISBLANK(C2), "D",IF(ISNUMBER(SEARCH("6+",C2)), "C",IF(TODAY()-C2<1460, "C", IF(TODAY()-C2<2920, "B","A"))))