PDA

View Full Version : highlight cells between two dates in cluding the cells with the dates



josephm
06-13-2008, 09:46 AM
i need some help here seriously.

I have two tables one in Sheet1 the other in Sheet2.

these two tables are indentical in everyway.


when u enter dates in sheet1's table in
sheet2 table will represent the dates in sheet1 by filling the cells between the two dates including the cells with the two dates.

see attached sheet.

grichey
06-13-2008, 09:56 AM
I don't understand whats supposed to happen bw sheets.

Fill in sheet 1 and 2 with what you think the results should be and highlight what shoould be happening.

josephm
06-13-2008, 10:15 AM
thanks i know i am even confused and its my sheet...

ok i found a solution but i need a way to place a color pallete on each cell in a range, so that after the user enters a date they can change the font color of the date.

marshybid
06-13-2008, 10:41 AM
thanks i know i am even confused and its my sheet...

ok i found a solution but i need a way to place a color pallete on each cell in a range, so that after the user enters a date they can change the font color of the date.

Hi, This thread is asking exactly the same question that you raised in thread:

http://vbaexpress.com/forum/showthread.php?t=20157

Above, you say that you have now found a solution to getting the correct cells in Sheet2 greyed out.

Is thread

http://vbaexpress.com/forum/showthread.php?t=20157

now solved then?? If so, you can mark the thread as solved in thread tools, but also can you post the solution.

I was looking at a solution for you, but as you have one now I don't need to.

Marshybid:hi: