i have a sheet that fills in colums if one of the cells
has a certain value in it like this =IF(A1="DEB",R24,"")

Which put the value in or R24 if A1 = deb Which workd fine
BUT is there a way to copy that cells color as well as the value in there?

If you Need More Examples Please down load the sheet from my brothers sever
Thanx in advance DEBBZ :)

http://www.kevin.dynip.com/debz.xls