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

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)

"Yashes" wrote in message
...
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

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

Yashes wrote:
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

On Tue, 24 Oct 2006 14:35:02 -0700, Yashes
wrote:

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
__________________________