Formatting a cell containing text
Closed
markyprest
Posts
1
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 28, 2017
-
Jul 28, 2017 at 07:04 AM
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 - Jul 28, 2017 at 11:57 AM
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 - Jul 28, 2017 at 11:57 AM
Related:
- Formatting a cell containing text
- Clear only the formatting from the selected cell - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
1 response
stankirsolkar
Posts
6
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 31, 2017
Jul 28, 2017 at 11:57 AM
Jul 28, 2017 at 11:57 AM
You can do this using conditional formatting.
First select the range in which you want this.
Then go to Home --> Conditional Formatting --> New Rule.
Use the below formula in conditional formatting: =IF($A1="Yes",TRUE,FALSE)
This formula assumes you have Yes/No in cell A1 (adjust according to your data). Specify the color in conditional formatting.
Now when you enter Yes in column 1, it will change the row color.
First select the range in which you want this.
Then go to Home --> Conditional Formatting --> New Rule.
Use the below formula in conditional formatting: =IF($A1="Yes",TRUE,FALSE)
This formula assumes you have Yes/No in cell A1 (adjust according to your data). Specify the color in conditional formatting.
Now when you enter Yes in column 1, it will change the row color.
