CONDITIONAL FORMAT

[jammoca]

i have a drop box linked to cell A1

in cell C1 i have a vlookup returning a name using A1 as a reference

in cell G5 i have a name that is a result of ..

='Rank Orders (RAW)'!AT5

when I check that the name in C1 and G5 are identical using =exact(c1,g5) it says "true", but when I apply a conditional format to G5 requesting it to highlight the cell in yellow if it is the same as C1 it does nothing

any clues ??

 

[Andrew Poulsom]

Did you try your EXACT formula as a Conditional Formatting formula?

 

[jammoca]

Solved a keg and a swedish lap dancer are on their way to you in gratitude

 

[Richard Schollar]

Solved a keg and a swedish lap dancer are on their way to you in gratitude

Bloody hell! And I thought answering questions was a purely altruistic exercise!!! I can see why you have over 20,000 posts now Andrew

 

[fairwinds]

a swedish lap dancer

We don't have such animals.

 

[Lewiy]

Are these rewards graded on question difficulty?......Is there a list somewhere? (perhaps a lookup table).......What do I need to do to get 5 cheesecakes and a life-time's supply of Jelly Babies???

 

[Andrew Poulsom]

Solved a keg and a swedish lap dancer are on their way to you in gratitude

Bloody hell! And I thought answering questions was a purely altruistic exercise!!! I can see why you have over 20,000 posts now Andrew

I hope they arrive in time for the weekend! :wink:

 

[Lewiy]

I hope they arrive in time for the weekend!

You'll be lucky, looks like their coming from Australia and the state our postal system's in at the moment, I be surprised if they arrive before Christmas!!