PDA

View Full Version : code to change text colour



n1kk1
01-17-2008, 09:04 AM
Hi, I have a code written already that changes the colour of a cell based on certain criteria, what I can't work out is how to change the text colour within certain conditions.

I have attached a file, for example in the 'Jan' tab column F31, is looking in the 'Companies' worksheet, at the moment I have manually changed the colour of this text but do you know if there is a way it can return the text colour as it is set in the 'Companies' tab?

Any help on this would be appreciated!