Odd blue box in cell with a formula

**TyTotaler** · 02-18-2011, 07:00 PM

Hello all.

I'm making a payroll sheet and I have two columns at the end for each employee where I use a formula to add up the hours for both regular and overtime.

However, as you can see in the attached picture, the very first cell with the formula displays this blue box/gradient that takes up half of the cell. It doesn't seem to do anything or alert me to some error I made and it doesn't happen with any other cell except for this one. Right-clicking gave me no information about it, either.

I wouldn't mind so much, except that it also appears during a print preview and I'd rather not have this little oddity being there when I need to print this out. Does anyone know what this is and how to get rid of it?

Much appreciated.

**DonkeyOte** · 02-18-2011, 07:02 PM

Perhaps you have a Conditional Format Data Bar applied to the cell ?

**Cutter** · 02-18-2011, 07:03 PM

It looks like a Conditional Format.

**TyTotaler** · 02-18-2011, 07:59 PM

Ah, yes that was precisely it. I do vaguely remember accidentally hitting that a while ago now, haha. I just forgot about it when I saw no immediate change (and thought I hit CTRL+Z, oh well). Haven't used Excel in years and I guess it shows.

Thanks for the speedy help, guys.