Nothing in to 0 in excel.

sherwood

In Runtime
Messages
282
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.
 
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.
 
Back
Top Bottom