INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Keep up the good work - excellent site - i'd been looking for something like this for ages !..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > Office Suites > Microsoft: Office Forum

Excel 2010 - conditional formatting not working

Read More Threads Like This One

Goatman88 (MIS)

10 Jul 12 17:58

Office 2010 Pro on Windows 7 64bit

A user has been complaining that conditional formatting doesn't work in Excel 2010 on certain files. The only way he can get it to work is if he saves as an older format (xls).

He found one possible link is that the problem files are always exports from Access.

Has anybody ever seen this?

SkipVought (Programmer)

10 Jul 12 20:21

Hi,

The export data may appear to be numerical, but actually be TEXT, often DATE values.

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

xlbo (MIS)

10 Jul 12 22:49

seconded!

what kind of tests are theconditional formatting doing?

If they are looking up dates or performng calcs on numerical values this is more than likely the culprit

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244: How to get the best answers before you ask a question

SkipVought (Programmer)

11 Jul 12 8:29

Geoff,

When you answered this thread, you were, with respect to me, "down under!" _{But not now, so where does this lead?} Hope that all is well with you "down under!"

Skip,
_{Just traded in my old subtlety...

for a NUANCE!}

Goatman88 (MIS)

11 Jul 12 11:13

Everyone,

Good Point!

I'll check and see if indeed the numerical values are being exported as text. I know he's doing < or > tests on the numbers.

Odd though that when he saves it as the older format (xls) it works and that he never had this problem with Excel 2007.

Mouldheels (TechnicalUser)

13 Jul 12 10:36

Those pesky programmers are always playing those sort of tricks on us excel users by ouputting obvious numerical fields as text of with spaces to pad them out to make them look pretty in reports.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: Office