ok, let's see if I can explain this in a non-confusing way. I have a workbook with several tabs and each tab contains
essential the same data. Anyway, each column is associated with a month of the year. The workbook is a tracking record of all
our employee trainings and what we do is type in the date that we've received the training report. They only have to complete
this training every other month and so only every other month is filled.
Here's what I would like it to do.
First, coloring Key: Purple means the report is due that month, green means we've received it.
Say I have
four months: April, May, June, July
-If April is filled (with a date) then the cell in June-on the same row-should
be colored purple (meaning that June is when the next report is due).
-If May is filled with a date, then the
adjacent June cell should be blank (meaning no report is required that month.
-Then, if June has been highlighted
as purple because a report is due that month, as soon as a date is entered in, the cell color should change to green.
-And, because I don't want the entire report to be purple until data is entered: If both April and May are blank,
then June should also be blank.
-and if possible, if no data is entered after a certain date, the cell color
I've got the purple to work and be blank if something in the cell before it with the following:
Using a formula to determine which cell to format: =LEFT(F3,1)="" (This is when I'm in cell G3)
do you have it recognize if something is filled with data without putting a range in, and when there's no data, instead of
Lot's of questions, but only one big one. Any help would be appreciated. I do know that if I did
=LEFT(G3,1)="" (again, when in cell G3) it'll turn blank if I type data in G3, but it won't turn blank if there's
data in F3.