Forum Discussion

Rajeev_Raghavan

Copper Contributor

Feb 22, 2020

Solved

Conditional formatting with wildcard

is it possible to fill the row with *New*

SergeiBaklan
Feb 22, 2020
Rajeev_Raghavan

Please use

=ISNUMBER(SEARCH("NEW",B2))

4 Replies

Haytham Amairah
Silver Contributor
Feb 22, 2020
Rajeev_Raghavan

Hi,

Try this formula instead:
=SEARCH("new",$I2)

Hope that helps
- Rajeev_Raghavan
  Copper Contributor
  Feb 23, 2020
  Thanks for the quick support.Haytham Amairah
SergeiBaklan
Diamond Contributor
Feb 22, 2020
Rajeev_Raghavan

Please use

=ISNUMBER(SEARCH("NEW",B2))
- Rajeev_Raghavan
  Copper Contributor
  Feb 23, 2020
  Thanks for the quick support. SergeiBaklan

Resources