How to make a cell copy the fill colour of another cell

C

Chase

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.
 
G

Gary''s Student

You need to create the exact test in the destination cell that matches the
test in the source cell. For example, If the conditional format in A1 is
Value is 3, then in A2 it would be Formula is =A1=3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
How can i put text in a cell depending on colour 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change the colour of a cell if another named cell is blank 2
How to equal a cell in another worksheet incl fill colour 3
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Excel 2007 conditional formatting & cell colour. 2
Copy corresponding cell in Column B if cell in A contains certain text? 1

Top