How do I shade cells using the "IF" function?
 

I am trying to shade a cell using the "IF" function. What code would I put
in the "Value if True" space in order for the function to shade the cell
automatically? Anyone know how to do that, because I can't find it in "Help"?

Thanks,
Robert

Hi
formulas can't change cell formats. But have a look at 'Format - Conditional
Format' to achieve your goal

"Kaz" wrote:

I am trying to shade a cell using the "IF" function. What code would I put
in the "Value if True" space in order for the function to shade the cell
automatically? Anyone know how to do that, because I can't find it in "Help"?

Thanks,
Robert

Use Conditional Formatting


"Kaz" wrote in message
...
I am trying to shade a cell using the "IF" function. What code would I
put
in the "Value if True" space in order for the function to shade the cell
automatically? Anyone know how to do that, because I can't find it in
"Help"?

Thanks,
Robert

Hi,

Can you paste your formula in your message ?And are you using your
formula in conditional formatting ?

Regards

Govind.

Kaz wrote:

I am trying to shade a cell using the "IF" function. What code would I put
in the "Value if True" space in order for the function to shade the cell
automatically? Anyone know how to do that, because I can't find it in "Help"?

Thanks,
Robert