Related:
- Conditional Formatting
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Phone formatting software for pc - Download - File management
2 responses
I assume you are using a spreadsheet application.
Depending on your application, there are different ways to do this.
But basically you go to the cell you want to format - in your case B2
Select the option for conditional formatting from the drop menus.
Choose the first format option.
Choose the way the decision will be based.
In this case by FORMULA not Value.
type the formula $A$1=1
then Format what happens when that formula is true by selecting the Pattern, or color the cell is to change to.
Repeat for other formatting options.
Save or Apply.
Copy the formatting to the other cells, or while still on the cell click on the Format Painter (paintbrush) and click-hold-slide across B3-B6 to copy the format.
Depending on your application, there are different ways to do this.
But basically you go to the cell you want to format - in your case B2
Select the option for conditional formatting from the drop menus.
Choose the first format option.
Choose the way the decision will be based.
In this case by FORMULA not Value.
type the formula $A$1=1
then Format what happens when that formula is true by selecting the Pattern, or color the cell is to change to.
Repeat for other formatting options.
Save or Apply.
Copy the formatting to the other cells, or while still on the cell click on the Format Painter (paintbrush) and click-hold-slide across B3-B6 to copy the format.