condition

[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

[Bryan Hessey]

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.

---

[stevekirk]

HI Bryan,

thanks working great


I NEARLY GOT THERE
I PUT AN "IF" INSTEAD OF AN " AND" AND IT WOULD NOT WORK .

JUST A FEW MORE MONTHS TRAINING

steve