New and exciting things

K

Khanjohn

Ok here si the biggie for me.

Say I have data in A3:A8, in C4 ihas a formula that seeks out data from
another area in sheet and will return Data matching one or more of the Cells
in A3:A8. How can i make it make the data that matches in A3:A8 Bpld or
highlight the cell? I dont use VBA yet as its far down the road for me.

Example



A3 Banana
A4 Orange C4 Orange
A5 Apple
A6 Pear
A7 Plum
A8 Pineapple

want it to

A3 Banana
A4 Orange (Bold) (or Highlighted) C4 Orange
A5 Apple
A6 Pear
A7 Plum
A8 Pineapple

Still havent figured out how to make it match multiples yet but may have to
change my formula to do that so single would be good for now.
 
J

JE McGimpsey

One way:

Select A3:A8. Choose Format/Conditional formatting. Use the dropdowns
and input box to read

CF1: Cell Value is equal to =$C$4
Format: <font>/<bold> or <pattern>/<highlight color>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top