| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the colour of a logic expression
Hey guys I have this logic expression in a spreadsheet =IF(C19C18,"YES","NO") What i want to do is if it returns a value of NO make the text red. Is this possible? I have seen the conditional formatting, but i think this would only work with 2 cells with numbers in. So i could apply that to my C19 cell but not to another cell that is looking at both of those cells. Hopefully someone can help Thanks in advance -- cjrrussell ------------------------------------------------------------------------ cjrrussell's Profile: http://www.excelforum.com/member.php...o&userid=19788 View this thread: http://www.excelforum.com/showthread...hreadid=491828 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the colour of a logic expression
Surely, you would just test for YES or NO in the CF?
-- HTH RP (remove nothere from the email address if mailing direct) "cjrrussell" wrote in message ... Hey guys I have this logic expression in a spreadsheet =IF(C19C18,"YES","NO") What i want to do is if it returns a value of NO make the text red. Is this possible? I have seen the conditional formatting, but i think this would only work with 2 cells with numbers in. So i could apply that to my C19 cell but not to another cell that is looking at both of those cells. Hopefully someone can help Thanks in advance -- cjrrussell ------------------------------------------------------------------------ cjrrussell's Profile: http://www.excelforum.com/member.php...o&userid=19788 View this thread: http://www.excelforum.com/showthread...hreadid=491828 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the colour of a logic expression
Thanks for the reply I was not aware you could do that with conditional formatting. Do you know how i would go about do that? -- cjrrussell ------------------------------------------------------------------------ cjrrussell's Profile: http://www.excelforum.com/member.php...o&userid=19788 View this thread: http://www.excelforum.com/showthread...hreadid=491828 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the colour of a logic expression
Ahh i have done it You have to set 2 conditions for the cell 1 says if equal to yes make it this colour the other says if equal to no make it this colour Thanks for your help -- cjrrussell ------------------------------------------------------------------------ cjrrussell's Profile: http://www.excelforum.com/member.php...o&userid=19788 View this thread: http://www.excelforum.com/showthread...hreadid=491828 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the colour of a logic expression
Exactly, well discovered.
Bob "cjrrussell" wrote in message ... Ahh i have done it You have to set 2 conditions for the cell 1 says if equal to yes make it this colour the other says if equal to no make it this colour Thanks for your help -- cjrrussell ------------------------------------------------------------------------ cjrrussell's Profile: http://www.excelforum.com/member.php...o&userid=19788 View this thread: http://www.excelforum.com/showthread...hreadid=491828 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wording's Colour Change for Logic Function | Excel Discussion (Misc queries) | |||
| Changing the Colour of a comment | Excel Discussion (Misc queries) | |||
| changing cell colour on click | Excel Discussion (Misc queries) | |||
| Wording's Colour Change for Logic Function | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Linear Mode
