Conditional formatting

[BJSinger7623]

So I have a row of information, one of those cells is the date, let's say G5. I'd like for the whole row to highlight in a color if the current date (when the sheet is opened) is AFTER that date. Does that make sense and is that do-able? Thank you so much in advance!

 

[Eric W]

Try:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G
1	Header1	Header2	Header3	Header4	Header5	Header6	Date
2	A21	A22	A23	A24	A25	A26	11/1/2021
3	A31	A32	A33	A34	A35	A36	11/2/2021
4	A41	A42	A43	A44	A45	A46	4/1/2021
5	A51	A52	A53	A54	A55	A56	12/1/2021
6	A61	A62	A63	A64	A65	A66	4/4/2021
7	A71	A72	A73	A74	A75	A76	5/5/2021
8	A81	A82	A83	A84	A85	A86	12/25/2021
9	A91	A92	A93	A94	A95	A96	12/31/2021
10	A101	A102	A103	A104	A105	A106	1/1/2022
11
12
Sheet33

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:G12	Expression	=$G2<TODAY()	text	NO

 

[BJSinger7623]

Try:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G
1	Header1	Header2	Header3	Header4	Header5	Header6	Date
2	A21	A22	A23	A24	A25	A26	11/1/2021
3	A31	A32	A33	A34	A35	A36	11/2/2021
4	A41	A42	A43	A44	A45	A46	4/1/2021
5	A51	A52	A53	A54	A55	A56	12/1/2021
6	A61	A62	A63	A64	A65	A66	4/4/2021
7	A71	A72	A73	A74	A75	A76	5/5/2021
8	A81	A82	A83	A84	A85	A86	12/25/2021
9	A91	A92	A93	A94	A95	A96	12/31/2021
10	A101	A102	A103	A104	A105	A106	1/1/2022
11
12
Sheet33

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:G12	Expression	=$G2<TODAY()	text	NO

Sorry to ask - but any chance you could dumb it down to Step 1 to the final product for me please? I'm looking and I'm just not seeing where to even start.

 

[BJSinger7623]

Try:

Book1 (version 1).xlsb
	A	B	C	D	E	F	G
1	Header1	Header2	Header3	Header4	Header5	Header6	Date
2	A21	A22	A23	A24	A25	A26	11/1/2021
3	A31	A32	A33	A34	A35	A36	11/2/2021
4	A41	A42	A43	A44	A45	A46	4/1/2021
5	A51	A52	A53	A54	A55	A56	12/1/2021
6	A61	A62	A63	A64	A65	A66	4/4/2021
7	A71	A72	A73	A74	A75	A76	5/5/2021
8	A81	A82	A83	A84	A85	A86	12/25/2021
9	A91	A92	A93	A94	A95	A96	12/31/2021
10	A101	A102	A103	A104	A105	A106	1/1/2022
11
12
Sheet33

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:G12	Expression	=$G2<TODAY()	text	NO

I GOT IT!!!! Thank you so much!

 

[Eric W]

Sure.

Open your workbook. Select the range that you want to apply the Conditional Formatting (CF) to. If you have one row, say A2:G2, select A2:G2. If you have several rows, select all of them, A2:G100 for example.

Once you have selected the range, from the Home tab, click Conditional Formatting > New Rule > Use a formula to determine which cells to format > and put this in the formula box:

=$G2<TODAY()

where G is the column with the date in it, and 2 is the top row of your range. Then click Format... , pick the Fill tab, and click on the color you want. Click OK until you've exited all the dialog boxes.


Looks like you got it already! Good job! Glad I could help a bit! ?