Reputation: 61
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
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<>"")
Upvotes: 2