I am trying to utilize conditional formatting logic and for an unknown reason I cannot get it to function correctly on other spreadsheets and/or tabs.
The new tab I added data to is entitled: Testing
The conditional formatting rule that is working is on tab: Q_2871141 (I received this logic from Fanpages a couple weeks ago)
I have copied the exact formula to an additional tab and to other spreadsheets and cannot determine why it won't work as it does on the 1st tab. The data format on the new tab is the same as is on the tab that is working correctly.
My New tab - "Testing"
Tab that is working - "Q_2871141"
The goal of the formula is to compare rows with the same value in column B and highlight the differences for any subsequent rows, as it does on the 1st tab.
Any help to resolve my issue is very much appreciated.