What I am looking to do is, to highlight a row when 2 conditions are met. one of the cells is formatted as a Date (00/00/0000).
The worksheet is set up as a tool log with many tools listed each on their own row. When someone checks out the tool there name is entered in the same row the E column. The dated they check out the tool is entered in the same row in Column G and the dated the tool is returned is in Column H.
I want to hight light the row when the tool is out and un highlighted when it is returned.
Here is what I have tryied. I could be way off base.
=IF(AND(NOT(ISBLANK(E5)),(NOT(ISBLANK(H5)))),TRUE,FALSE)
The worksheet is set up as a tool log with many tools listed each on their own row. When someone checks out the tool there name is entered in the same row the E column. The dated they check out the tool is entered in the same row in Column G and the dated the tool is returned is in Column H.
I want to hight light the row when the tool is out and un highlighted when it is returned.
Here is what I have tryied. I could be way off base.
=IF(AND(NOT(ISBLANK(E5)),(NOT(ISBLANK(H5)))),TRUE,FALSE)