Hi again, can anyone tell me if I can do this. I want to creat a very narrow column, only one number/digit wide at the far right of my sheet and when I make an entry for example a tick it will change the font colour of another entry in the same row.
Thanks for the link Vog, interesting site. Still not sure exactly how to do what I require which is if I enter any value in column Q then the font colour of the cell in column J on the same row changes to black.
Hi Vog, I have not yet worked out a formula, looking on the lines of enter into row Q Cell value greater than 0 =J change the font to black Obviously not using these words this is the basic idea. Whilst I found the link helpful re Excell it also seems to be a lesson in American speedtalk, can it be paused or slowed down so that the less experienced of us have a chance to take it on board without having to do constant replay