NotSoSmartGuy Posted March 6, 2009 Share Posted March 6, 2009 this is what I want to code in excel if (c1 < 0) paint cell d1 red, else paint cell d1 green anyone know how to cde that? Thanks Link to comment Share on other sites More sharing options...
0 +Dick Montage Subscriber² Posted March 6, 2009 Subscriber² Share Posted March 6, 2009 Conditional formatting is all you need. No code. Link to comment Share on other sites More sharing options...
0 Bookieass Posted March 7, 2009 Share Posted March 7, 2009 Conditional formatting is all you need. No code. +1 (Y)look here http://www.contextures.com/xlcondFormat01.html for your sample tutorialHope it helps :D Link to comment Share on other sites More sharing options...
0 NotSoSmartGuy Posted March 9, 2009 Author Share Posted March 9, 2009 thank you very much, worked out well Link to comment Share on other sites More sharing options...
Question
NotSoSmartGuy
this is what I want to code in excel
if (c1 < 0) paint cell d1 red, else paint cell d1 green
anyone know how to cde that?
Thanks
Link to comment
Share on other sites
3 answers to this question
Recommended Posts