Conditional formating
 

I want some of my cells to automatically change color by conditional formating.

1 condition for coloring/formating is that a separte cell on the spreadsheet
contains text ... how do I set the conditions for this?

1 condition for coloring/formating is that a separate cell has a number
above 0.. how do I set the condition for this?

Conditional formating
 

=ISTEXT($A$2)

=AND(ISNUMBER($A$2),$A$20)

--


Regards,


Peo Sjoblom

"Kathrine" wrote in message
...
I want some of my cells to automatically change color by conditional
formating.

1 condition for coloring/formating is that a separte cell on the
spreadsheet
contains text ... how do I set the conditions for this?

1 condition for coloring/formating is that a separate cell has a number
above 0.. how do I set the condition for this?

Conditional formating
 

To use Peo's formulas select the cell you want formatted. Select conditional
formatting. Change from cell value is to formula is and add the formulas.
--
HTH...

Jim Thomlinson


"Peo Sjoblom" wrote:

=ISTEXT($A$2)

=AND(ISNUMBER($A$2),$A$20)

--


Regards,


Peo Sjoblom

"Kathrine" wrote in message
...
I want some of my cells to automatically change color by conditional
formating.

1 condition for coloring/formating is that a separte cell on the
spreadsheet
contains text ... how do I set the conditions for this?

1 condition for coloring/formating is that a separate cell has a number
above 0.. how do I set the condition for this?

Conditional formating
 

Select A1 the formatcfcondition 1formula is:

=ISTEXT($B$1) format to green

Condition2Formula is:

=$B$10 format to red


Gord Dibben MS Excel MVP

On Mon, 29 Sep 2008 13:34:10 -0700, Kathrine
wrote:

I want some of my cells to automatically change color by conditional formating.

1 condition for coloring/formating is that a separte cell on the spreadsheet
contains text ... how do I set the conditions for this?

1 condition for coloring/formating is that a separate cell has a number
above 0.. how do I set the condition for this?