Thread: How do I set up automatic colour fill of a cell prompted by text?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
  
Posts: 90
Default How do I set up automatic colour fill of a cell prompted by text?
A column in a spreadsheet shows the staus of each project. The cells are
colour coded to clearly show the status eg. Red = Overdue, Green = Complete
etc.. Is it possible to prompt the cell to colour automatically by entered
text eg. Type Overdue and the cell automatically turns red?
Reply With QuoteReply With Quote