Related:
- Conditional Formatting
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Code for formatting android phone - Guide
- Copy conditional formatting to other cells ✓ - Excel Forum
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.