Link value of one cell based on another cell in Google sheets ?

Use of Google sheets is growing day by day and there are lots of tips and tricks that are really helpful for you in your daily work. The Google Sheet is a great way to share and collaborate in your workspace and it also provides you with lots of new features.

 

In this post we will be explaining on how to do conditional formatting in Google Sheets bases on cells value. You can use conditional formatting in Google Sheets to change the format of a cell based on the value in another cell.

1.                   1. Select the cells you want to apply formatting to.

2. Click on "Format" in the top menu and select "Conditional formatting".
3. In the "Format cells if" section, choose the condition that you want to apply.
4. In the value or formula section, you can either specify a value or reference another cell.

2. To customize based on other cell value , In the Format cell Rule -> select Format cell is as.. Custom formula is .


3. Now suppose you have to check F2 cell to condition your value (eg if F2 is 1 then change colour to Green), then type the formula as =$F2=1

2. Click on the format you want to apply like color and scale etc  and then click "Done".

 

Hope this helps you.