On 2002-04-22 08:09, paulrus wrote:
If I can't use an array, how do I format based on a list of states? I don't quite understand how what you wrote would work if Excel has no idea that I only want those specific states to be colored differently.
On 2002-04-22 08:23, paulrus wrote:
You can't use reference to other sheets using conditional formatting.... or at least that's what Excel is telling me...
On 2002-04-22 08:39, paulrus wrote:
I moved them to A70-84 and changed it to read:
=COUNTIF($A$70:$A$84,$E6)
However any row I apply this to changes color regardless of whether or not it matches A70-84.