Formatting a cell containing text
Closed
markyprest
Posts
1
Registration date
Friday 28 July 2017
Status
Member
Last seen
28 July 2017
-
28 Jul 2017 à 07:04
stankirsolkar Posts 6 Registration date Friday 28 July 2017 Status Member Last seen 31 July 2017 - 28 Jul 2017 à 11:57
stankirsolkar Posts 6 Registration date Friday 28 July 2017 Status Member Last seen 31 July 2017 - 28 Jul 2017 à 11:57
Related:
- Formatting a cell containing text
- Excel clear formatting - Guide
- Conditional formatting based on another cell text - Excel Forum
- Excel conditional formatting based on another cell - Excel Forum
- How to delete a cell in word - Guide
- Formatting windows 7 - Guide
1 response
stankirsolkar
Posts
6
Registration date
Friday 28 July 2017
Status
Member
Last seen
31 July 2017
28 Jul 2017 à 11:57
28 Jul 2017 à 11:57
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.
