condition

Originally Posted by stevekirk

hi,

in column u i have the word "egbd" in it within other text
in coulmn e there will be a number

what i need is a formlular that looks for the word egbd, and if the number is less that 200 in the e column make the cell red

thanks

steve

Select the E column, Format, Conditional Format, Formula is

=AND(NOT(ISERROR(FIND("egbd",U1,E1<200))))

set to required colour.

---