Conditional Formatting
does XL97 have conditional formatting?
-----Original Message-----
No real need for code
Select the range and go
FormatConditional Formatting
Change the left dropdown to "Formula Is" andenter:
=FIND("BUSINESS",UPPER(A1))
where the 1st cell in the range is A1
.
|