The cells to be colored are based on the selection, so you
selected all cells -- well you could have anyway.

The formula is based on the active cell and determines whether
the cell will be colored.
If A1 is the active cell and you used
=A1=1 then each cell would be evaluated against 1
If you use $A1 in stead of the active cell then each cell
will be evaluated to what is in column A and the active
cell could be any cell on row 1.

More information on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SystemHack" wrote Works absolutely perfect man .. thanks !!

I know have already helped alot but would you mind explaining how you
get that formula ? If not no biggie .. it's doing what I need thanks.