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