I have a link excel worksheet from access database query which the information on the worksheet is refresh daily. I would like to have the rows highlighted in yellow when the below conditions meet:
column H has 30 NET
column Z has TVLS PROGRAM.
The name on the worksheet is UPS - No Date. I have tried the conditional formatting but it only highlight when I click on the cell.
Is it possible to have this task complete on refresh or do I have to have macro?
I have attach an example (removed connections)
Bookmarks