Highlight Row with different color in which the number is Lying

[parankush]

I have a data table in which I have Name of party, Bill number, Bill date, Days, Bill Amount and outstanding amount.
What I want is, if the number of days fall under 30-45 the row should be colored with a particular color code and if it is more than 45 then with another specific color code.
The row should be coloured only ill column F.
Please help mw with it.
The color codes are as follows -

Range Date	Color Code
More than 45	Red - 255 Green - 204 Blue - 255
Between 30 to 45	Red - 242 Green - 220 Blue - 219

The data set is

Name of the party	Bill No.	Bill Date	Days	BILL Amount	Outstanding
Amazon		/ /		1,32,760	1,27,564
	3362​	20/10/2022	54​	29,469	24,273
	3557​	31/10/2022	43​	37,700	37,700
	3644​	03/11/2022	40​	13,308	13,308
	4155​	01/12/2022	12​	1,930	1,930
	4264​	09/12/2022	4​	12,269	12,269
Flipkart		/ /		4,114	4,114
	3878​	17/11/2022	26​	4,114	4,114
Myntra		/ /		1,799	878
	4023​	24/11/2022	19​	1,799	878
Cloudtail		/ /		4,015	4,015
	3634​	03/11/2022	40​	4,015	4,015
Retailx		/ /		2,037	2,037
	4262​	09/12/2022	4​	2,037	2,037
EZ Elc		/ /		8,266	7,068
	3629​	03/11/2022	40​	3,209	2,011
	3877​	17/11/2022	26​	2,275	2,275
	4263​	09/12/2022	4​	2,782	2,782

 

[etaf]

The row should be coloured only ill column F.

only is what in column F

i dont seem to be able to set RGB on my version of conditional formatting

I'll look into that - it may need to have VBA to do the RGB , so i may not been able to help - sorry about that

Book6
	A	B	C	D	E	F	G	H	I	J	K
1	Name of the party	Bill No.	Bill Date	Days	BILL Amount	Outstanding
2	Amazon		/ /		1,32,760	1,27,564			Range Date	Color Code
3		3362	10/20/22	54	29,469	24,273			More than 45	Red - 255 Green - 204 Blue - 255
4		3557	10/31/22	43	37,700	37,700			Between 30 to 45	Red - 242 Green - 220 Blue - 219
5		3644	11/3/22	40	13,308	13,308
6		4155	12/1/22	12	1,930	1,930
7		4264	12/9/22	4	12,269	12,269
8	Flipkart		/ /		4,114	4,114
9		3878	11/17/22	26	4,114	4,114
10	Myntra		/ /		1,799	878
11		4023	11/24/22	19	1,799	878
12	Cloudtail		/ /		4,015	4,015
13		3634	11/3/22	40	4,015	4,015
14	Retailx		/ /		2,037	2,037
15		4262	12/9/22	4	2,037	2,037
16	EZ Elc		/ /		8,266	7,068
17		3629	11/3/22	40	3,209	2,011
18		3877	11/17/22	26	2,275	2,275
19		4263	12/9/22	4	2,782	2,782
20
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F19	Expression	=$D2>45	text	YES
A2:F19	Expression	=$D2>=30	text	YES

 

[etaf]

I went to this site

RGB Color Codes Chart 🎨

RGB color codes chart, RGB color picker, RGB color table.

www.rapidtables.com

and setup the colour RGB value
then on conditional formatting - i used the colour picker to select the colour

Book6
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Name of the party	Bill No.	Bill Date	Days	BILL Amount	Outstanding
2	Amazon		/ /		1,32,760	1,27,564			Range Date	Color Code
3		3362	10/20/22	54	29,469	24,273			More than 45	Red - 255 Green - 204 Blue - 255
4		3557	10/31/22	43	37,700	37,700			Between 30 to 45	Red - 242 Green - 220 Blue - 219
5		3644	11/3/22	40	13,308	13,308
6		4155	12/1/22	12	1,930	1,930
7		4264	12/9/22	4	12,269	12,269
8	Flipkart		/ /		4,114	4,114
9		3878	11/17/22	26	4,114	4,114
10	Myntra		/ /		1,799	878
11		4023	11/24/22	19	1,799	878
12	Cloudtail		/ /		4,015	4,015
13		3634	11/3/22	40	4,015	4,015
14	Retailx		/ /		2,037	2,037
15		4262	12/9/22	4	2,037	2,037
16	EZ Elc		/ /		8,266	7,068
17		3629	11/3/22	40	3,209	2,011
18		3877	11/17/22	26	2,275	2,275
19		4263	12/9/22	4	2,782	2,782
20
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:F19	Expression	=$D2>45	text	YES
A2:F19	Expression	=$D2>=30	text	NO