Apply Conditional Formatting By Using. By default it will apply Colour Scale formatting. To highlight cells according to multiple conditions being met you can use the IF and AND Functions within a Conditional Formatting rule.
In the next section you will find more information on all the settings. Now select Use a formula to determine which cells to format Step 3. To Apply Conditional Formatting in Google Sheets.
By default it will apply Colour Scale formatting.
In the next section you will find more information on all the settings. NOTE Google Sheets currently provides fewer conditional formatting options and controls than Excel for example no data bars or icon sets. Now under Format values where a formula is true apply the formula as A2. If you are using Excel 2013 or later versions you can use the AutoFill handle to apply the conditional rule to adjacent rows.
