C
chief
hello,
some background on the problem
i am using vb with excel spreadsheets to set up a tool inventor
program. i have it set up so that all the required info can be inpu
except for my last column (F). in this column is the "return date
which unlike the rest of the sheet is input at a later time. what
want to do is have the rows which have a signed out tool and no retur
date in the F column cell highlighted yellow in order to show they ar
still outstanding. If that sounded confusing, its like this; someon
will take a tool, i will click on my tab buttons to fill in th
information in cells A7 to E7 for example (this is where th
highlighting is suppose to happen), then when the tool gets returned,
go into the sheet and click on the calendar date causing the F7 cell t
be filled with a date and causing the highlighted A7 to E7 cells to g
back to their original cell color. i have searched high and low for
formula and have been unsuccessul.
is there anybody outhere that can offer some advice.
thank yo
some background on the problem
i am using vb with excel spreadsheets to set up a tool inventor
program. i have it set up so that all the required info can be inpu
except for my last column (F). in this column is the "return date
which unlike the rest of the sheet is input at a later time. what
want to do is have the rows which have a signed out tool and no retur
date in the F column cell highlighted yellow in order to show they ar
still outstanding. If that sounded confusing, its like this; someon
will take a tool, i will click on my tab buttons to fill in th
information in cells A7 to E7 for example (this is where th
highlighting is suppose to happen), then when the tool gets returned,
go into the sheet and click on the calendar date causing the F7 cell t
be filled with a date and causing the highlighted A7 to E7 cells to g
back to their original cell color. i have searched high and low for
formula and have been unsuccessul.
is there anybody outhere that can offer some advice.
thank yo