How to Conditionally Format Other Cells or Rranges

[Rene]

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?

 

[PCLIVE]

This is still done using the conditional Formatting option. Just change
from "Cell Value Is" to "Formula Is".
Then use the appropriate formula. Example, if the word "DONE" were to show
up in cell A1, then highlight the range you want to change as a result of
that and enter this formula.

=A1="Done"

HTH,
Paul

 

[David Biddulph]

If you need a whole range highlighted as a result of a value in one column,
then the CF formula will need *absolute* addressing, so =$A1="Done" if you
want a range spreading across a row highlighted as a dependency on column A,
or =$A$1="Done" if a range covering multiple rows and columns is to be
dependent on A1.

 

[PCLIVE]

Good catch.

--

If you need a whole range highlighted as a result of a value in one
column, then the CF formula will need *absolute* addressing, so
=$A1="Done" if you want a range spreading across a row highlighted as a
dependency on column A, or =$A$1="Done" if a range covering multiple rows
and columns is to be dependent on A1.