shading cells as the output of an if statment

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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
 
Back
Top