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

How to Conditionally Format Other Cells or Rranges
 

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

--

"Rene" wrote in message
...
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

How to Conditionally Format Other Cells or Rranges
 

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.
--
David Biddulph

"PCLIVE" wrote in message
...
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

--

"Rene" wrote in message
...
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

How to Conditionally Format Other Cells or Rranges
 

Good catch.

--

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
--
David Biddulph

"PCLIVE" wrote in message
...
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

--

"Rene" wrote in message
...
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