MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
Is there a way (I think there is) whereby if I type a certain letter in a cell, it can alter the colour formatting of the cell to represent what I have typed. E.g, I type a '+' and it turns red, I type a '-' it turns green.
Posted : 21/09/2009 1:36 pm
You need to use conditional formatting to do that, simple enough if you read the help files
Posted : 21/09/2009 1:41 pm
Aye.
conditional formatting
Posted : 21/09/2009 1:41 pm
Just done a quick search for a tutorial, have a look here:
http://en.allexperts.com/q/Excel-1059/Change-cell-color-based.htm
Posted : 21/09/2009 1:44 pm
Topic starter
done. excellent, thanks.
Posted : 21/09/2009 1:48 pm