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 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: