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
- Count if cell contains number - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
1 reply
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.