ExcelBanter - changing cell formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - changing cell formula (https://www.excelbanter.com/excel-worksheet-functions/226044-changing-cell-formula.html)

specialc

changing cell formula

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?

Mike H

changing cell formula

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?

All times are GMT +1. The time now is 03:02 AM.