Notifications
Clear all
Topic starter
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. 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.
Posted : 15/06/2019 2:16 pm
Hello,
If you can attach a sample file showing what you try to do and so fort it will be a lot easier to check and give you a relevant answer.
Posted : 16/06/2019 12:49 am
If you selected the whole of column D, then D1 would be active by default, so your formula should be:
"=D1=$Q$3"
Posted : 16/06/2019 4:53 am
