Hi There,

Is it possible to change the contents of a cell based on a result of
ANOTHER cell.

Eg I would like to highlight in Red the word MICE (in Cell A3) because
cell B3 = 1
A B
Dogs 1
Cats 1
MICE 2

Thanks guys

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***

With Cell A3 Active goto Format, Conditional Formatting,
From dropdown "CellIs" select FormulaIS and in the box type in = B31
Click on Pattern select the RED, and OK out..
Should work.

"Darin Kramer" wrote:


Hi There,

Is it possible to change the contents of a cell based on a result of
ANOTHER cell.

Eg I would like to highlight in Red the word MICE (in Cell A3) because
cell B3 = 1
A B
Dogs 1
Cats 1
MICE 2

Thanks guys

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***

Hi Darin

Select the cell with the word MICE (A3), then Format|Conditional formatting
For Condition 1, select Formula Is (from drop down menu), then enter the
following into the adjacent box:
=$B$3=1
Then click the Format button and select whatever font you want for the word
"Mice" (e.g. red/bold)

HTH, Phil



"Darin Kramer" wrote in message
...

Hi There,

Is it possible to change the contents of a cell based on a result of
ANOTHER cell.

Eg I would like to highlight in Red the word MICE (in Cell A3) because
cell B3 = 1
A B
Dogs 1
Cats 1
MICE 2

Thanks guys

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***