Thread: Conditional Formatting

Hi,

How to format a column in which:

a) only duplicate values get colored (e.g, green) {and not alongwith the orginal value}
b) any number that is in decimal form also gets colored (e.g, 2.2, 1.5, 10.98, etc.)

Regards
Sushil

a) Say you have your values in A1:A100. Starting with A2 (since A1 would, by definition, be unique in the range so far), try =Countif(A$1:A1,A2)>0.
b) Starting with A1, try =Mod(A1,1)