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)
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
- Select range for example:
E2:H7
- New rule
- Formula
=AND($E2<>"",$H2<>"")
 
Upvote 0
I'm glad to help you. Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,214,861
Messages
6,121,969
Members
449,059
Latest member
oculus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top