Spreadsheet Question

[oreosmom]

Hello,

I am trying to update Oreo's spreadsheet, but for some reason, the colors for the blood glucose numbers are not filling in the spaces. Help! Any ideas would be welcomed!!!

Thanks,

Carol,

Oreo's mom

 

[Wendy&Tiggy(GA)]

I hate it when it does that. You have lost the conditional formatting. Heres what you do.

1. go to a cell that currently has the colour coding in it. any one will do. Click on it.
2. now click on the little paint roller icon top left above your sheet. Thats the "paste format" button.
3. Now click on the cell you want to add the format/colours too. If you hold the mouse down at this point you can select a whole range of cells.

Let me know how you get on
Wendy