Hi,
I wish to C.F. cells in a worksheet with the same colour for different cell values. I.E. I have a worksheet with columns A to G that are for Sun to Sat. I then have rows A1 to 50. Within the worksheet there are, on different rows in different cells, names such as SK or II or HLA and DIL and others.
I want to colour SK and II the same colour and HLA and perhaps DIL another colour. I can format them one at a time, but as you are only allowed three different C.F.'s in a workbook, I have quickly run out of options. As there are quite a few names throughout the workbook all standing for different reasons, this is getting messy. Is there a way to CF cells together with different names?
At the moment I am using the formula in CF 'cell value is equal to ="SK" then I format it the way I like. I would like to add II to the format and make the two the same, as they are basically similar formats in my workbook.
Does this post make any sense? I can post a example, but when I tried the other day, the workbook was to large, and the format colours had been taken out.
I wish to C.F. cells in a worksheet with the same colour for different cell values. I.E. I have a worksheet with columns A to G that are for Sun to Sat. I then have rows A1 to 50. Within the worksheet there are, on different rows in different cells, names such as SK or II or HLA and DIL and others.
I want to colour SK and II the same colour and HLA and perhaps DIL another colour. I can format them one at a time, but as you are only allowed three different C.F.'s in a workbook, I have quickly run out of options. As there are quite a few names throughout the workbook all standing for different reasons, this is getting messy. Is there a way to CF cells together with different names?
At the moment I am using the formula in CF 'cell value is equal to ="SK" then I format it the way I like. I would like to add II to the format and make the two the same, as they are basically similar formats in my workbook.
Does this post make any sense? I can post a example, but when I tried the other day, the workbook was to large, and the format colours had been taken out.