NEW col C is populated by the formula =if($A1=1,B1,"") filled down
B is occasionaly a whole number (say) 3 or above - I wish to highlight such occurence.
Whe I apply the Conditional format (say) >2.9 the entire Col C highlights???
Please - there is surely a simple fix for this...