The cell formatting menu allows you to customize how data values will show, add custom borders, and add formatting that will only show if a condition is met.
Number
See Formatting data.
Border
Alter the width and color of the cell borders. To set a color for a cell border, enter a hex value or select a color from the picker. To set the width of the border, enter a pixel value, or use the arrows to make the border thicker or thinner.
Make Borders Uniform: Select whether to use one value for all the borders, or to modify each border individually.
Conditional
To set or modify the format of a cell based on a conditional formula:
Click
Add to create a
new condition.
From the Action list, select an action to occur if the condition is met.
Click the formula
icon and
enter a formula for the condition. The formula must evaluate to True or
False.
To use the value of the current cell in the formula, use the function CellValue(). Click
Cell Value to insert CellValue() into the formula.