New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Coloring based cell and duplicates in the column

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Coloring based cell and duplicates in the column

Postby k0st4din » Fri Sep 09, 2016 2:28 am

Hello friends,
please for help from you because I have something I can not find solution to my problem.
in cell $C$12 have an amount as $ 256.25, I want to find where repeated this amount in column H:H and where there are matches them to me color, but not only in the column H:H and stain and the cell itself $C$12 in the same color.
examples:
$C$12 = 256.25
H2 = 256.25
H15 = 256.25
H36 = 256.25
I want to be stained as red cell vlookup ie $C$12 and all the other matches. Ie do not know how to color $C$12 in the same color.
I would be grateful if there is a solution to my problem.
Regards
  • 0

So ...
1. *Consider well what is your wish.
2. *Make a sample table
3. *Describe in detail what you want to happen is to be understood, not only by yourself.
4. And if you help someone else who needs help. :) ;)
k0st4din
Excel Junkie
 
Posts: 217
Joined: Dec 7, 2011
Location: UK
Reputation: 3
Excel Version: 2003, 2007

Re: Coloring based cell and duplicates in the column

Postby gebobs » Tue Sep 27, 2016 4:00 pm

Is this what you are looking for? Column H is conditionally formatted to have a red background if the cell value is equal to C12.
  • 2

You do not have the required permissions to view the files attached to this post.
gebobs
Regular
 
Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 62 guests