writa a page on conditional formatting with examples.
Answers
Answered by
0
(◍•ᴗ•◍)(◍•ᴗ•◍)(◍•ᴗ•◍)(◍•ᴗ•◍)(◍•ᴗ•◍)(◍•ᴗ•◍)
Answered by
1
Answer:
How to create a conditional formatting rule using a formula
Select the cells you want to format. ...
On the Home tab, in the Styles group, click Conditional formatting > New Rule…
In the New Formatting Rule window, select Use a formula to determine which cells to format.
Enter the formula in the corresponding box.
Explanation:
Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula. For example, you can have a cell appear bold only when the value of the cell is greater than 100.
Similar questions