Conditional formatting column problem

Folks,
In my spreadsheet I have an array formula that idenitifies the last column used. This appears to be working ok.
I now would like to use conditional formatting to highlight that last used column.
Here's what is not working:
=$B$12=Column(A1)

Open in new window


$B$12 tells me what column in the array A1:X10 was last used. The value returned was a 4 which is column 4 and that is correct. My conditional formatting range is from $A$1:$X$10. However, I cannot get column 4 shaded

I've even changed the conditional formatting rule to this with no luck:
=$B$12=COLUMN(A1:X1)

Open in new window

Frank FreeseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NBVCCommented:
The first one should work.  Make sure the Applies To range in your CF condition equals: =$A$2:$X$10
0
Frank FreeseAuthor Commented:
That failed also. Here's the workbook
Columnformat.xlsm
0
Frank FreeseAuthor Commented:
I found the problem - stupid me.
Please share your finding for points
0
barry houdiniCommented:
It's $C$12 not $B$12 isn't it?

regards, barry

PS you could get the same cells formatted without using the formula in C12. Use the same "applies to" range with this CF formula

=(B2="")*(A2<>"")
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank FreeseAuthor Commented:
And the winner is - - Barry. Good catch. Just another senior moment for me.
Thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.