VBA Coding

[ADJ2RGJ]

1) Question relates to implementing a VBA code within a standard Excel 365 spreadsheet (size A1:AB1000). Column headers in row 1.
2) Date field in column B (format dd.mm.yyyy)
3) Datedif between entry in column B and Now() shown in column Y (in months)
4) 1st routine - If y2 > 9 then interior colour of (entire) row = "yellow"
5) 2nd routine - If y2 < 6 then interior colour of (entire) row = "blue"
6) 3rd routine - If y2 > 6 < 9 then interior colour of (entire) row = "white"
7) 4th routine - if text column O = "complete" and text in column P = "complete" 1st then interior colour of (entire) row = "grey"
8) In the case of '7' the row colour would automatically update on column data change
9) Items '3' to '6' should automatically update when the spreadsheet is opened.

Any advice would be helpful.

 

[DanteAmor]

Hi and welcome to MrExcel

Your request can be resolved with conditional formatting, create a rule for each color. You don't need to run any macros and the colors update automatically.

DANTE AMOR
	A	B	C											N	O	P	Q							X	Y	Z	AA	AB	AC
1	A	B	C											N	O	P	Q							X	Y	Z	A	B
2		23-ene																							15
3		24-ene													Complete										14
4		25-ene														Complete									13
5		26-ene													Complete	Complete									12
6		27-ene																							11
7		28-ene																							10
8		29-ene																							9
9		30-ene													Complete	Complete									8
10		31-ene																							7
11		01-feb														Complete									6
12		02-feb																							5
13		03-feb													Complete	Complete									4
14		04-feb																							3
15
Hoja4

Cell Formulas
Range	Formula
Y2:Y14	Y2	=DATEDIF(B2,TODAY(),"d")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:AB100	Expression	=$Y2=""	text	YES
A2:AB100	Expression	=AND($O2="Complete",$P2="Complete")	text	NO
A2:AB100	Expression	=$Y2>9	text	NO
A2:AB100	Expression	=$Y2<6	text	NO
A2:AB100	Expression	=AND($Y2>=6,$Y2<=9)	text	NO

 

[ADJ2RGJ]

Thank you very much. I had seen similar questions to mine in the past where the answer had been to loop through every row, but appreciate your approach and answer.