If count goes over certain value change cell or number to red.

[ef0rel1]

Could this formula be modified, so if the count goes over 12, either the number or cell would change to the color red.


=SUMPRODUCT((B6:H6="V")+(N6:T6="V")+(Z6:AF6="V")+(AL6:AR6="V")+(AX6:BD6="V")+(BJ6:BP6="V"))


I'm using excel 2010, could you show what the formula would look like and how it's added to the above formula.

Thanks

 

[MrKowz]

Take a look at Conditional Formatting.

 

[ef0rel1]

MrKowz thanks for pointing me in the right direction the Conditional Formatting work out fine.