| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| conditional formatting glitches | Excel Discussion (Misc queries) | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| conditional formatting | Excel Discussion (Misc queries) | |||
| cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Linear Mode
