conditional formatting?
 

This is what i've got so far
Condition1
Formula Is ="define when true$Y$8<$H$218"

what is wrong? i need my sheet to indicate a problem between the two
cells. I want to format the error as the text being red.

any help would be great


--
rini247bini
------------------------------------------------------------------------
rini247bini's Profile: http://www.excelforum.com/member.php...o&userid=36943
View this thread: http://www.excelforum.com/showthread...hreadid=566545

conditional formatting?
 

Try:

Formula Is "=$Y$8<$H$218" without double quotes

HTH

"rini247bini" wrote:


This is what i've got so far
Condition1
Formula Is ="define when true$Y$8<$H$218"

what is wrong? i need my sheet to indicate a problem between the two
cells. I want to format the error as the text being red.

any help would be great


--
rini247bini
------------------------------------------------------------------------
rini247bini's Profile: http://www.excelforum.com/member.php...o&userid=36943
View this thread: http://www.excelforum.com/showthread...hreadid=566545

conditional formatting?
 

Formula Is =$Y$8<$H$218

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"rini247bini" wrote in message
...
|
| This is what i've got so far
| Condition1
| Formula Is ="define when true$Y$8<$H$218"
|
| what is wrong? i need my sheet to indicate a problem between the two
| cells. I want to format the error as the text being red.
|
| any help would be great
|
|
| --
| rini247bini
| ------------------------------------------------------------------------
| rini247bini's Profile: http://www.excelforum.com/member.php...o&userid=36943
| View this thread: http://www.excelforum.com/showthread...hreadid=566545
|

conditional formatting?
 

i tried your suggestion and it worked!
thanks for your help Toppers!


--
rini247bini
------------------------------------------------------------------------
rini247bini's Profile: http://www.excelforum.com/member.php...o&userid=36943
View this thread: http://www.excelforum.com/showthread...hreadid=566545

conditional formatting?
 

and thank you too Niek! I didn't see your post sorry. thanks for your
quick reply =)


--
rini247bini
------------------------------------------------------------------------
rini247bini's Profile: http://www.excelforum.com/member.php...o&userid=36943
View this thread: http://www.excelforum.com/showthread...hreadid=566545