shading cells as the output of an if statment

[Paul]

Hello,

Can I do this:

If(a2>50,shade cell b4 red,)

I would like to shade the cell if the if statement is true.

Thanks
Paul

 

[JT]

Paul,

Select the cell that you want to shade (B4 in this case?),
then click on FORMAT on the menu bar, then click
Conditional Formatting... At the first drop-down
select "Formula Is", then type =(A2>50)
Now click on the FORMAT... button and choose the cell
formatting that you want to be applied if the above
logical test is true. Click OK once you've chosen your
formats, then OK again to accept the conditional formats

Hope it helps

 

[Phantom]

Big words man, but how's it done? Hmmm?