LinkBack URL
About LinkBacks
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 turns red.
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)
How 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.
Register To Reply
Bookmarks