JinkyJulie
New Member
- Joined
- Jun 28, 2005
- Messages
- 26
Hello everyone,
I have 4 spreadsheets with about 500 cells each. I wish to format the data based on the cell background colour.
Examples...
If the cell bg colour is blue, I would like the data to be White and in bold...
If the cell is yellow, I would like the data to be displayed in Black and also bolded.
I thought Conditional formatting would be the best route, but I cannot get it to work... I used to colour each cell by hand... It takes far too long...
Any help would be very much apprecitated...
Thanks you, again...
Julie
I have 4 spreadsheets with about 500 cells each. I wish to format the data based on the cell background colour.
Examples...
If the cell bg colour is blue, I would like the data to be White and in bold...
If the cell is yellow, I would like the data to be displayed in Black and also bolded.
I thought Conditional formatting would be the best route, but I cannot get it to work... I used to colour each cell by hand... It takes far too long...
Any help would be very much apprecitated...
Thanks you, again...
Julie