Excel 2002 - Conditional formatting?

  Mr. Chips 09:51 07 Nov 2010
Locked

Is conditional formatting available in Excel 2002?

I thought it was, but can't get the option to come up on the drop down menus.

Any advice available on this one please?

  Picklefactory 13:48 07 Nov 2010

Yep, it should be there.
Format menu > Conditional Formatting

It was introduced in Office '97 if memory serves

  Picklefactory 13:50 07 Nov 2010

This might help

click here

  octal 14:41 07 Nov 2010

It definitely is there because I use it at work extensively, I would be stumped without it.

If all else fails then it is in Open Office, I use it on there as well.

  VoG II 14:52 07 Nov 2010

You might have to click on the arrow at the bottom of the Format menu to see it.

  Mr. Chips 15:08 07 Nov 2010

Weel folks ... thnaks ... but no go.

There is no arow at the bottom of the list ... it is fully extended.

I have tried using the Office Professional XP CD to 'Add and Remove' features and then to 'Repair Office', both to no avail.

The bizarre thing is that I run the same installation on my Lapt-top Vista-Home ... and it appears there.

Really annoying.

Thanks for the time you have spent trying to help,... it is appreciated.

  VoG II 15:12 07 Nov 2010

Try holding down ALT then press o followed by d

  Mr. Chips 22:36 07 Nov 2010

Still no joy .... most odd.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?