View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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