Conditional Formating another cell

[Darin Kramer]

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

 

[Jim May]

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

 

[Phil C]

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