Change cell fill color from function
 

Hello,

Is it possible to dynamically change the fill color of a cell by using
the funciton for that cell.

I would like the back color to chage red or green for a fail/pass
condition calculated by another function.

Would anyone have an answer for this?

Thanks.

Mike

Change cell fill color from function
 

Never mind. I found the Conditional Formating under the Format menu.

Mike

Change cell fill color from function
 

Hi Mike,

Apply condtional formatting, using the fail/pass condition in the CF
formula.


---
Regards,
Norman



"Mike" wrote in message
oups.com...
Hello,

Is it possible to dynamically change the fill color of a cell by using
the funciton for that cell.

I would like the back color to chage red or green for a fail/pass
condition calculated by another function.

Would anyone have an answer for this?

Thanks.

Mike