This is my first post so please be kind
The simple problem is I require more than the standard 3 conditional cell formatting that excel offers.
Basically I want the cells to be a certain colour dependant on what is in the cell.
The Cells will contain strings. For example if the cell contained the string "Apple" then the cell wud be read.
I want this for about 10 different strings and therefore 10 different colours.
I dont mind using icolor or whatever it is as I can convert that.
Then last thing I ask is that it be used through the workbook as I will have a few sheets that it needs to run on and dont want to have to put the code in for each individual sheet.
Any questions let me know.
Thanks in advance