conditional format

[allgeef]

I want B1 to highlight if A1 contains the text "net value". What would the conditional format be in B1? Regards, Gary

[windy58]

In conditional format screen select Use a formula to determine which cells value to format.
Then in the Format values where this formula is true place the following: =$A$1="net value"

Windy

[Ace_XL]

Try

=ISNUMBER(SEARCH("Net Value",A1))

[allgeef]

Very nice, thanks much.

[Tony Valko]

Try

=ISNUMBER(SEARCH("Net Value",A1))

No need for the ISNUMBER function:

=SEARCH("Net Value",A1)

SEARCH will return a number from 1 to N or a #VALUE! error. When it returns a number (any number other than 0) the format will be applied. When it returns the #VALUE! error the format will not be applied.