changing cell formula

  • Thread starter Thread starter specialc
  • Start date Start date
S

specialc

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?
 
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
 
Back
Top