Solved

Format cell colour based on value

Posted on 2011-09-09
3
277 Views
Last Modified: 2012-05-12
Guys I know it is possible to use conditional format to alter cells but it is limited.
I need to have a way to enter a value in a cell say A1 and a range of cells say G3:AK1000 to change colour and all matching to show up in red and everything else to go white.

Can you help

Regards

Darren
0
Comment
Question by:DarrenJackson
3 Comments
 
LVL 18

Assisted Solution

by:x-men
x-men earned 250 total points
ID: 36511214
here's an example.

every "ABC" in the range $A$1:$C$9 turns red


EE.xlsx
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 250 total points
ID: 36511225
If you mean, "make every cell in g3:ak1000 that is equal to the value in A1 red", then create a formula-based Conditional Formatting rule for g3:ak1000 using this formula:

=$A$1

and select your formatting (red fill).

Simple :)
0
 

Author Comment

by:DarrenJackson
ID: 36511504
Sometimes you can make a job a little too hard lol my only excuse for this is it is Friday lol

guys thanks for pointing out the obviouse.

Enjoy your weekends

Darren
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question