Conditional Formatting

Cal Groudas
|
12 steps
|
39 seconds

Hover over the cell color menu item.

Click "Conditional formatting"

\[OPTIONAL\] Select the range to which you wish to apply the rule.

Click "Add rule"

If you have a range selected when you click "Add rule" then that range will automatically be added.

Either verify that your range is correct OR type in a new range.

Click the formula input bar.

Either select your formula from the dropdown or write your own formula.

If a formula has the text "change me" in it then you can easily customize those formulas by doing exactly that--change the values

Make changes in the formatting styling panel to visualize when the formatting would look like if applied.

Click "Add rule"

Your formatting rules will now be visible for the range specified.

- Ranges can include cross-sheet references. - Formulas will be evaluated for each cell in the range. - If the formula evaluates to TRUE, the style will be applied. - Use the CELL keyword to refer to the cell that's being evaluated. - Use the COL keyword to refer to another cell in the same row (for example, COL\[A\] < 5). - You can use all operators and functions in the formula input.

In spreadsheet formulas, **case sensitivity** is important to keep in mind, especially when working with **named ranges**. For example, if you have a named range called `SalesData`, referring to it as `salesdata` in a formula will result in an error. Always ensure you match the exact case of any named ranges, functions, or references you use. This attention to case sensitivity helps avoid potential formula errors and ensures accurate calculations.