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


Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
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:


and select your formatting (red fill).

Simple :)
x-menConnect With a Mentor IT super heroCommented:
here's an example.

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

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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.