David Steinhoff
New Member
Members
Forum Posts: 1
Member Since:
June 15, 2019
June 15, 2019
Offline
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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Karin Jongerius, RACHEL LAWRENCE, Jordan Helman, Nicole White
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Kevin Sanderson
wer klaus
Forum Stats:
Groups: 3
Forums: 24
Topics: 6880
Posts: 30156
Member Stats:
Guest Posters: 49
Members: 33700
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —