| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make a cell copy the fill colour of another cell
I am trying to make a booking spreadsheet with each tab being a month with
all the days and then another tab being a 2008 summary sheet. I want when i fill in dates on one sheet (say colour them red to show it is booked on those days) to automatically fill in the same colour in the cell corresponding to the same date on the other tab/sheet. I have found conditional formatting to get me very close. As i think i can make it so if i write something in the cell then the other will change to red. But cant get it to just copy the format of the other. Any help would be awesome. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cell that are fomated a particular fill colour | Excel Discussion (Misc queries) | |||
| How to make a cell copy the info from another (background colour i | New Users to Excel | |||
| I cannot add fill colour to any cell, or use coloured text | Excel Worksheet Functions | |||
| Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
Threaded Mode
