...
You can also change the colour of an entire row based on a cell value.
1. Getting Started
To set Conditional Formatting, select the Tools | Cell Actions menu option then select the Formatting tab.
...
To apply formatting to an existing button or range, click on the NEW FORMATTING dropdown and select the name of the range from the list. In this case a button range called CHAT has been selected:
...
2. How do I set all cells in the range to have the same format?
To set all cells in the range to the same format:
...
In this example all cells in the range will be formatted with black text and and an orange background:
...
3. How do I change the formatting of a cell based on its value?
To set different formats according to the value of the cell, you have to create a set of Conditions and associated colours. For each condition:
...
if the cell contains the value "To Do" then its text will be white and background red
if the cell contains the value "In Progress" then its text will be black and background yellow
if the cell contains the value "Done" then its text will be white and background green
...
4. How do I change the formatting of an entire row based on a cell's value?
To change the colour of an entire row based on the value of a single cell, follow the same process as in 2 and 3 above, but instead of selecting SELF from the CELL/S dropdown, select ROW instead. In the following example, the conditional formatting will be applied to the entire row rather than just the individual cells:
...
5. How do I change the formatting of a cell based on another cell's value?
You can set the colour of one cell based on the value of another by passing absolute cell co-ordinates to the =VALUE() function.
...