Conditional Formatting Help

Question

I'm working on a document that has combined cells, with names, blanks and dates. I'm wondering the easiest way to format when the dates are 11 months or older, for the cells that have dates in them directly. I've looked at some previous answers on the forum, but can't figure out how to tailor them for my needs.

My form looks like this, with "Chart for plans due" being entirely in A1. The names of the houses are all combined cells for a cleaner look.

CHART FOR PLANS DUE
Client Name	Plam 1	Plan 2	Plan 3	Plan 4	Plan 5	Plan 6	Plan 7	Plan 8	Plan 9	Plan 10	Plan 11
Flinstone House:
Fred	1/15/2023	8/11/2023	10/22/2023	5/9/2024	2/22/2024	5/9/2024	2/27/2024	In Progress	12/19/2024	11/6/2023	NA
Wilma	1/16/2023	11/01/2024	No Consent	2/26/2024	2/22/2024	11/3/2024	02/27/2024	In Progress	12/20/2024	5/21/2024	NA
Pebbles	11/04/2024	10/19/2023	10/19/2023	10/13/2023	2/22/2024	11/3/2024	2/28/2024	In Progress	5/9/2024	11/6/2023	NA
Dino	1/16/2023	7/12/2024	2/29/2024	2/23/2024	2/22/2024	9/23/2024	3/23/2024	In Progress	12/19/2024	12/12/2023	NA
Rubble House
Barny	1/11/2023	1/22/2024	1/22/2024	1/22/2024	NA	12/26/2024	1/15/2024	In Progress	11/15/2024	12/16/2024	NA
Betty	1/1/2022	Rep 7 Agrmnt	No Consent	12/23/2024	NA	6/12/2024	2/1/2024	In Progress	2/8/2024	2/8/2024	NA
Bam Bam	1/16/2023	1/16/2024	1/14/2024	1/14/2024	11/8/2024	12/26/2024	1/15/2024	In Progress	11/15/2024	11/15/2024	NA
Jetson Cottage
George	3/22/2021	Commiteeship	1/14/2024	1/14/2024	1/8/2024	1/14/2024	1/30/2024	10/11/2024	1/13/2023	1/14/2024	10/11/2024
Jane	1/30/2024	10/9/2024	1/2/2024	1/2/2024	2/8/2024	10/11/2024	1/30/2024		10/10/2024	10/10/2024	1/29/2024
Gummi Bear
Sunni	11/12/2024	2/13/2024	2/13/2024	2/7/2024	10/7/2024	10/9/2024	2/20/2024	10/22/2024	10/9/2024	5/17/2024	NA
Tummi	6/22/2024	8/2/2024	1/20/2024	1/20/2024	NA	6/7/2024	9/10/2024	10/22/2024	5/17/2024	5/17/2024	NA
Grammi	11/11/2024	1/23/2024	1/23/2024	1/23/2024	NA	1/5/2024	1/9/2024	1/9/2024	10/9/2024	2/9/2024	NA
Cubbi	11/07/2024	Commiteeship	1/21/2024	1/21/2024	10/7/2024	2/7/2024	5/29/2024	7/23/2024	3/25/2024	10/9/2024	NA

Answer 1

Select the entire range. A1 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.

Enter the formula

=AND(A1<>"", A1<=EDATE(TODAY(), -11))

Click Format...
Activate the Fill tab.
Select a fill color.
Click OK, then click OK again.

Answer 2

Yes, thanks. The "dates" in the worksheet are actually text values.

I converted them to real dates, and now the conditional formatting works.

See https://www.dropbox.com/scl/fi/xlfyfsi7id4x06rotzy7w/Excel-Error.xlsx?rlkey=bztksi2h28mlun6a6pyzix03f&dl=1

Answer 3

Excel Error.xlsx

Does that work?

Answer 4

Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 5

Hey. Thanks for the super quick response!! I'm not sure what I am doing wrong, but when I follow these directions and copy and paste the formula in, nothing happens. I'll keep trying to fiddle with it.

Thanks again!