Macro Conditional Format Help

[jjsauer]

Hello,
I am trying to pull a few different things together from different sources and getting nowhere.

I need my conditional formatting to be dynamic and allow me to add rows when I need to (The in-excel version makes new rules and gets messy with conditional formatting). My understanding is I would need to integrate a macro "conditional formatting" instead of a in-excel version.

The macro would need to look at say column "AC" and find a specific CAPS letter, then go to a cell (same row, different column) and change the background color.

The "AC" column could have any combination of adeADE, but for example I only need the ones with a CAP "A" to change the color of the cell in column "J".

I know how to use FOR EACH statements, but not sure how to line it up with finding a specific CAPS letter. Any help would much be appreciated.

This was one of my previous excel conditional formatting formulas (randomly chosen as an example): =NOT(ISERR(FIND("E",X3:X2000)))

Thanks in advance!

 

[BobUmlas]

Select ALL of column J & apply this:
=NOT(ISERR(FIND("A",AC1)))

 

[jjsauer]

Perfect! I had tried "AC:AC"...thank you very much BobUmlas!