I am trying to highlight all cells in a column that match the value in a specific cell. I select the header for column D, create a new rule in Conditional Formatting using the formula "=D4=$Q$3" to match all cells in the column against the current value in Q3. D4 is the first numeric cell in the D column. However, other cells are highlighted that don't match the value in Q3. Some are higher and some are lower. I've tried a number of different formulas that all give wrong results. Any help is appreciated.
Bookmarks