To test a cell for fill color see:

http://www.cpearson.com/excel/Colors.aspx
--
Gary''s Student - gsnu200786


"Matt" wrote:

I am trying to test to see if a cell is color filled, then if it is fill that
cell with a value divided by the number of colored cells in the row. i've
tried an isblank statemnt but keep getting stuck.