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
|