That's a good question. I have about 14 sheets I need to apply this formatting to and I need to sometimes be able to turn on/off the formatting for presenation purposes. Figured a macro allowing me to activate the formatting would be best but I'm open to suggestions. The other issue I had was with applying this formula relatively from cell to cell. The formula rule seem to stay the same through the range of data. I may not be using the CF menu correctly.