Conditional Format a column based on another
What is in column B, and why 3 highlighted.
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Karm" wrote in message
...
Column A has 100 entries of either 1,2 or 3 which are not necessarily
sorted
in order depending upon sorting in other columns but I want the minimum
value
in column B based on column A to remain conditionally formatted. i.e.
Column
B will always have three cells highlighted.
|