Check out 'Highlight cells that meet specific conditions' in help

--

HTH

RP
(remove nothere from the email address if mailing direct)


"wiz546" wrote in message
...
can Excel logical functions recognize cell color shading? For example, a
cell formula be created to add cells in a column that are shaded green and
ignore cells shaded blue?