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 (leaving the content) - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Count if cell contains number - Excel Forum
- If cell contains date then return value ✓ - Office Software 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.
