I am using the NETWORDAYS function in column T comparing column H and I. So far so Good, I then apply conditional fromatting to the values to where everything as a 0 has no fill everything between 1 and 3 days has a Green fill applied, everything between 4 and 6 days has a yellow fill and evrything >7 has a red fill. Works great. I then want to apply that fill to the other cells in the row, and bam it does not work. thoughts, suggestions? sheet will have at least a thousand rows and Ican't get it to work.