Previous Topic Next Topic

Conditional Formatting based on other cells

Closed
osiron23 Posts 1 Registration date Thursday October 20, 2016 Status Member Last seen October 20, 2016 - Oct 20, 2016 at 11:58 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 21, 2016 at 08:30 AM
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 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 21, 2016 at 08:30 AM
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses