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
- Count if cell contains number - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - 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.
