Hi,
This may be a simple solution but I seem to be having some issues with conditional formatting. I am using Data Validation and INDIRECT forumula to reference a list for drop down. I have three INDIRECT references for drop down which works fine. When I switch the select a cell that is not refenced in the drop down the previously selected cell remains the same. Ive tried using a Macro to reset but considering there are multiple drop down on the sheet this might not be the right approach (not sure). So I am using conditional formatting to highlight the cells that do not reference the INDIRECT cells. It works for 90% of the cells that I select but there are a few that are remaining highlighed even though they are being reference properly. Drop downs are cells B2:B5. I have attached the file for more details.
The spreadsheet has explanations on cells D2,D3,D5,D6.
Can someone please help?
Bookmarks