View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Aqib Rizvi Aqib Rizvi is offline
external usenet poster
 
Posts: 9
Default 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