• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

Format cell colour based on value

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
DarrenJackson
Asked:
DarrenJackson
2 Solutions
 
x-menIT super heroCommented:
here's an example.

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


EE.xlsx
0
 
Patrick MatthewsCommented:
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
 
DarrenJacksonAuthor Commented:
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now