how to create a if statement, if true turn colour

[Guest]

i need to create a "if statement" in Excel and i need to know how to make the
cell change colour if it is true

Thanks

 

[Bob Phillips]

You want conditional formatting

See http://www.contextures.com/xlCondFormat01.html

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

 

[Pete_UK]

You would have to use conditional formatting to change the colour of a
cell depending on its contents. Select the cell and Format |
Conditional Formatting - you will be presented with a panel where you
can select "Cell content is" or "Formula is" and complete the details
as appropriate. Then click the Format button to choose the foreground
or background colour and other formatting features.

Hope this helps.

Pete

 

[Richard Buttrey]

i need to create a "if statement" in Excel and i need to know how to make the
cell change colour if it is true

Thanks

Are you sure you really need an if statement?

Why not just use a conditional format? e.g.

"Cell Value is", "equal to", "the result of your proposed if statement
if true", then set format required.

HTH



__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________