'Conditional formatting for 2 different sheets
I am making a sheet which has a single log sheet and 2 calender's linked to the same. There are Domestic and international orders and i want to highlight the Only Indian orders in domestic calendar. Vlookup is not working. Please assist with any function or VBA code
I tried using index and match but to no avail
In the above image the blank colored cells are to be removed and only the cells which displays name should be colored
I tried this formula
=INDEX(Table26[[Country/Region]:[Status]],MATCH(G$5,Table26[Dispatch Date],0),7)
But,when i enter/copy paste the formula in conditional formatting, it shows a formula error pop up. Is my formula wrong and if yes what is the correction needed?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|