Conditional formating
Closed
Ducky
-
Sep 3, 2016 at 07:05 PM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- Conditional formating
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Conditional formatting if another cell contains any text ✓ - Forum - Excel
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Copy conditional formatting from one row to another ✓ - Forum - Excel
- If cell contains date then conditional format - Guide
1 reply
Mazzaropi
Sep 3, 2016 at 09:57 PM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Sep 3, 2016 at 09:57 PM
Ducky, Good evening.
Try to do:
Select B3:F21 cells.
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =$B$3="abc"
Choose RED as fill format
OK
Please, tell us if it works for you.
Try to do:
Select B3:F21 cells.
CF MENU --> NEW RULE --> USING FORMULA
Type it at field: =$B$3="abc"
Choose RED as fill format
OK
Please, tell us if it works for you.