user3507621
user3507621

Reputation: 61

Conditional formatting on Google Sheets

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?

Upvotes: 0

Views: 65

Answers (1)

Marios
Marios

Reputation: 27350

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<>"")

explanation

Upvotes: 2

Related Questions