sherwood In Runtime Messages 282 Sep 12, 2008 #1 Hey all, I am wondering if you can help me. In excel I would like it so blank cells will turn into '0'. Also I would like it so cells which has numbers in apart from '0' to turn into a color. If any of you can help me I would be greatful.
Hey all, I am wondering if you can help me. In excel I would like it so blank cells will turn into '0'. Also I would like it so cells which has numbers in apart from '0' to turn into a color. If any of you can help me I would be greatful.
I IAntDemo xxcobraxx Messages 6,224 Location England Sep 12, 2008 #2 I have no idea how to use the program but here are a few questions and answers that may help you http://www.mrexcel.com/qa.shtml
I have no idea how to use the program but here are a few questions and answers that may help you http://www.mrexcel.com/qa.shtml
OP OP sherwood In Runtime Messages 282 Sep 12, 2008 #3 Thank you very much. In the end I turned for 0 so it left blank spaces and also I used conditional formatting for the colour changing on the number.
Thank you very much. In the end I turned for 0 so it left blank spaces and also I used conditional formatting for the colour changing on the number.