RE: highlight dependent cells

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Conditional Formatting:

=OR($C1=$D$1,$C1=$D$2)


"Lindsay" wrote:

Hello,

I'm having trouble explaining my question, so I've come up with a simple
example.
Column C Column D
horse cat
cow dog
pig
cat
owl
dog

I would like the entries in Column C to highlight, if they match an entry in
Column D. In this case, C5 (cat) and C7 (dog) would highlight....is this
possible? Thanks so much!

.

Relevant Pages

  • Re: V-lookups

    (microsoft.public.excel)
  • Re: distance from a point to a set
    ... {dog, cat, pig} ... i don't care what you name 'em ...
    (sci.math)
  • Re: Im back and intersteing news from insurance
    ... Always remember, a cat looks down on man, a dog looks up to man, ... but a pig will look man right in the eye and see his equal". ...
    (alt.support.arthritis)
  • highlight dependent cells
    ... I would like the entries in Column C to highlight, if they match an entry in ...
    (microsoft.public.excel.worksheet.functions)
  • Re: try tahitian noni juice
    ... Always remember, a cat looks down on man, a dog looks up to man, ... but a pig will look man right in the eye and see his equal". ... Bbaylarry really had a sense of humor. ...
    (alt.support.arthritis)