Conditional formatting a highlight a row with 2 conditions, one being a date

trmason

New Member
Joined
Mar 6, 2013
Messages
10
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.
1574187561043.png

Here is what I have tryied. I could be way off base.
=IF(AND(NOT(ISBLANK(E5)),(NOT(ISBLANK(H5)))),TRUE,FALSE)
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
- Select range for example:
E2:H7
- New rule
- Formula
=AND($E2<>"",$H2<>"")
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
I'm glad to help you. Thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,002
Messages
5,545,439
Members
410,684
Latest member
LakTik
Top