How do I access conditional formatting please?
The option does not present itself in the 'Format' drop down box.
Do I need a special 'Add-In' please?
How do I access conditional formatting please?
The option does not present itself in the 'Format' drop down box.
Do I need a special 'Add-In' please?
its on the format menu, under Conditional Formatting!
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
Do you have all menu Items visible, 2003 has expanding menus, I'm not sure if 2002 does!
Last edited by squiggler47; 11-07-2010 at 09:54 AM. Reason: Changed 2003 to 2002!
post a screen shot if all else fails
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
This is what you should be seeing in office 2002
Mine looks like this:-
Untitled-1.jpg
is anything strange in tools/customise/options ?
You may want to check out this solution as well
Excel's menus are messed up
http://www.j-walk.com/ss/excel/usertips/tip076.htm
Dave.
It looks OK to me .. as may be seen on the attached.
Ticks in all except 'large icons'.
The bizarre thing is that I have the same installation on my lap-top which shows the conditional formatting option.
Also, when I open that excel spreadsheet (with conditional formating that I built on the lap-top, the conditional formatting works OK on the desk-top ... but still with no option in the desktop's formatting menu.
Is anyone able to give me a VBA coding alternative please.
I can use VBA in Access OK ... but I have no books on Excel VBA to try and work it out for myself.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks