Cond. Formatting depending of value in another sheet

J

Jonsson

Hi all,

I've tried to do conditional formatting whether the cellvalue i
another sheet is greater or smaller than the cellvalue I have in th
active cell.

I've tried to do "formula is" IF(B34<Sheet1!B34)and format, but it won
work.

Any help is apprecciated!!

//Thoma
 
P

Peo Sjoblom

Give the cell on sheet 1 a name (insert>name>define)
then refer to the name instead, also no need for the if function

=B34<MyName
 
J

Jerry W. Lewis

What do you mean by "it wont work"? 'It won't accept the formula'? or
'it accepts the formula, but but fails to respond to the condition'?

Fails to respond to the formula:
Edit your conditional format; you will find your formula enclosed in
quotes (a text constant instead of a live formula) if you didn't preceed
it with an equals sign.

Won't accept the formula:
Conditional format conditions cannot refer to other worksheets or
workbooks. They cannot explicitly refer to the current workbook, so the
Sheet1! prefix would not be allowed even if you were using it on Sheet1.
If you are not using it on Sheet1, you will have to have a cell on the
current sheet link to Sheet1!B34, and condition on that cell.

Also, the conditional format syntax is much more picky than worksheet
formulas. =IF(B34<B34) is a valid worksheet formula with implied
responses of True and False. It is not a valid condition format
formula, because it does not specifically give responses. Use
=IF(B34<B34,TRUE,FALSE) or more compactly =B34<B34

Jerry
 
Top