Format a cell in a table
Hello Gurus:
I have a table in Excel that represents a year-long date grid. The 31 columns are labeled 1 through 31 to represent the days. The 12 row labels are Jan through Dec to represent the 12 months. How would I:
1) Color in a cell that represents a date entered in a form, ie, for March 15th, the cell at the intersection of column 15 and row = Mar would be red or yellow filled. Is that possible? Or can an ‘X’ be entered there?
2) A different question and perhaps a bit trickier, if an ‘X’ is entered in this table say at that same intersection, can VBA calculate all the entries in the table before the X (ie, ‘8’ has been entered in several cells before the X) and sum them?
Thanks for any help!
|