Conditional formatting on Google Sheets

Question

I'm new to Google Sheets, and I'm looking to get my C5 cell filled with green if its value is equal to my A5 cell's value.

Can anyone help me with it?

And, is there a way to do it for the entire column? Like C5 equal with A5, C6 equal with A6, C7 equal with A7, etc...? — user3507621
– user3507621, Commented Sep 27, 2020 at 14:31

Marios · Accepted Answer · 2020-09-27 16:17:04Z

2

Right click on any cell in column C and then left click on conditional formatting. Choose the settings exactly as you see in the following screenshot and use the following custom formula:

=AND(C1=A1,C1<>"")

edited Sep 27, 2020 at 16:17

answered Sep 27, 2020 at 16:08

Marios

27.5k9 gold badges40 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3507621 Over a year ago

It said "Invalid formula", but it worked whit just =AND(C1=A1). Thanks a lot :) Can you help me with the same formula but to make C3 filled with red when different from A3 please? Many thanks in advance :)

Marios Over a year ago

@user3507621 just add another conditional formatting rule for the same column and create a custom formula C3<>A3 and choose color red.

Collectives™ on Stack Overflow

Conditional formatting on Google Sheets

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related