• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 271
  • Last Modified:

Conditional formatting column problem

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:

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:

Open in new window

Frank Freese
Frank Freese
  • 3
1 Solution
The first one should work.  Make sure the Applies To range in your CF condition equals: =$A$2:$X$10
Frank FreeseAuthor Commented:
That failed also. Here's the workbook
Frank FreeseAuthor Commented:
I found the problem - stupid me.
Please share your finding for points
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

Frank FreeseAuthor Commented:
And the winner is - - Barry. Good catch. Just another senior moment for me.
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now