Currently using Google Spreadsheets. I have 2 sheets - "Capping" and "Join Dates" I want cell B2 on Capping to turn red if cell A2 on Join Dates doesn't have the same numerical value. Both cell B2 and A2 have formulas within them that count cells with text in the given range.
On cell B2 of Capping I tried using the "Conditional Formatting" formula "Is Not Equal To" and then referenced the cell A2 on Join Dates. Even though the 2 cells have the same numerical value, cell B2 on Capping turned red. Is this happening because the 'Is Not Equal To" formula is targeting the formula within the referenced cell, rather than its numerical value?
Kind regards,
Jimmy.
Bookmarks