View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rene Rene is offline
external usenet poster
 
Posts: 74
Default How to Conditionally Format Other Cells or Rranges

I want to have a cell or a range of cells be formatted with a pattern or a
border or both, or even unprotected (if not too complicated) whenever another
cell in the Status column displays the string: "DONE". Is it possible to use
Conditional Formatting for that? Or would I have to use an IF statement
instead? I've managed to have a simple IF statement display directions
whenever the DONE text shows up in the Status column, but don't know if it's
feasible to use it with formatting of another range. Is it and if so, how?

--
Rene - Do appreciate your help