can excel 2007 do this in conditional formating?
A B Group Total
Bathtubs & Acc. 90325 4
Say, when you do a conditional format < 10 to the column labeled "total"
and I have it do a green fill.
I would like the cells ( Bathtubs & Acc.,90325 and 4) to be highlighted in
green.
I have tried but 90325 never get highlighted because it is greater than 10.
Is it possible?
Thanks