View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tjmcgee47
 
Posts: n/a
Default Can I auto hi-lite a cell if a certain phrase it typed?

I create my group's schedule with Excel. Is there any way that if I type a
particular word of abbreviation (i.e. PV for paid vacation) in a cell that it
will automatically highlight that cell? Want to be able to see at a glance
whether a person is in the office or off.