I am creating below conditional formatting rule in Apache POI. Issue Expected: The formula should highlight only invalid values in column ‘J’. Actual: But all values of the entire column ‘J’ get highlighted, even for valid values. Formula Full Code Required manual post-production in Excel Now I did the below steps Add three values in column ‘J’ named “State”. All