Hi,

I don't understand the question. You can't directly change a cell colour
with a formula but you can evaluate the formula result with conditional
formatting and change colour. What colours do you want and in what
circumstances?

Mike

"specialc" wrote:

I need to change the following formula so that I can modify the cell color:
=IF(COUNT(W15:W74)=0,"N/A",IF(W10=0,0,W10/COUNT(W15:W74))). Can anyone help
with this?