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

[Kaz]

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

 

[Frank Kabel]

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

 

[Paul Corrado]

Use Conditional Formatting

 

[Govind]

Hi,

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

Regards

Govind.