Conditional Formatting

[gtd526]

Hello,
Im not sure why Conditional Formatting is acting this way.
I assume, I might need a different formula.
thx

My Macro Copy_Talentos SAH Artists_ - EXCEL.xlsm
	A	B
1	Named Range
2	Name	Range
3	_xlfn.IFERROR	=#NAME?
4	_xlfn.MAXIFS	=#NAME?
5	_xlfn.MINIFS	=#NAME?
6	AAge	=Adults!$H:$H
7	ABday	=Adults!$I:$I
8	ADays	=Adults!$J:$J
9	ANames	=Adults!$B:$B
10	ASex	=Adults!$K:$K
11	KAge	=Kids!$H:$H
12	KBDay	=Kids!$I:$I
13	KDays	=Kids!$J:$J
14	KNames	=Kids!$B:$B
15	KRep	=Kids!$C:$C
16	KSex	=Kids!$K:$K
17	TAge	=Teens!$H:$H
18	TBDay	=Teens!$I:$I
19	TDays	=Teens!$J:$J
20	TNames	=Teens!$B:$B
21	TRep	=Teens!$C:$C
22	TSex	=Teens!$K:$K
Specs

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Expression	=LEFT($A2,1)="A"	text	NO
A:A	Expression	=LEFT($A2,1)="T"	text	NO
A:A	Expression	=LEFT($A2,1)="K"	text	NO

 

[Fluff]

The formula must refer to the first row in the applies to range.
As you are using the entire column it should be A1 not A2

 

[gtd526]

The formula must refer to the first row in the applies to range.
As you are using the entire column it should be A1 not A2

Works. Thank you for the input.

 

[Fluff]

You're welcome & thanks for the feedback.