Contains & conditional formatting
Closed
Ace
-
May 13, 2010 at 09:16 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 09:48 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 13, 2010 at 09:48 AM
Related:
- Contains & conditional formatting
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Formatting usb mac - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Conditional formatting 3 color scale percentages ✓ - Excel Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 13, 2010 at 09:48 AM
May 13, 2010 at 09:48 AM
You have to use conditional format and use a formula
Say this value is in column A
Then
Select Column A
Goto Conditional Formatting
Enter this formula
=IF(ISERROR(FIND("intervention plan", A1,1)), FALSE, TRUE)
Click on format in the conditional formatting dialog box and choose color and make the font bold
Say this value is in column A
Then
Select Column A
Goto Conditional Formatting
Enter this formula
=IF(ISERROR(FIND("intervention plan", A1,1)), FALSE, TRUE)
Click on format in the conditional formatting dialog box and choose color and make the font bold
