Conditional Formatting based on other cells [Closed]

Report
Posts
1
Registration date
Thursday October 20, 2016
Status
Member
Last seen
October 20, 2016
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
I'm relatively new to Excel and I was wondering how exactly to do the following:

A1=BALL
A2=CAT

How do I make it so that when B1=A1, then B1 is shaded green. But if B1=/= A1, then B1 is shaded red. Same thing for B2. If B2=A2, then B2 is green. If not, then B2 is red.

Essentially, I'd like columns B-K to be shaded according to their value in comparison to the column A.

I hope that wasn't too confusing. Thanks in advance!!!

1 reply

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
osiron23, Good morning.

Welcome here!

Try to use:
Select B1:K2
Conditional Format Menu --> Using Formula

Rule 1
=$A1=B1
Format:
Font BOLD, WHITE
Fill Color GREEN
OK

Rule 2
=$A1<>B1
Format:
Font BOLD, WHITE
Fill Color RED
OK

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!