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?
|