conditional format
Jack
Also try this
select cell A3
conditionally format with forumula is =A3="JSO"
select background colour and click OK
Format paint A3 to range A3:P200
where ever JSO is written the background colour will come
If you want JSO and jso both then the other two formulas are great.
Regards
Aqib Rizvi
|