Change cell colour based on sum

[BekPen]

I need to change the colour of a cell based on it's sum value.

I want to total hours worked (done) and if the total is more than a set value, to turn that cell red.

I have a feeling this is pretty simple but cannot wrap my head around it.

[shg]

Welcome to the forum.

See http://www.contextures.com/xlcondFormat01.html

[Paul]

Hi BekPen, welcome to the forum.

Take a look at Conditional Formatting (Format -> Conditional Formatting). There's many questions in the forum pertaining to this situation. Let us know if you need further assistance.

[BekPen]

Thanks - knew I should have had that extra cup of coffee today. My face is SO red right now!!