Solved

Format cell colour based on value

Posted on 2011-09-09
3
295 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

691 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