Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
97
Views
Topic starter
I'm trying to write a formal for a conditional formatting rule.
The function is HIGHLIGHT ALL CELLS THAT ARE WITHIN 3% OF D30
Hope this makes since.
Thanks, Ryan
Posted : 06/04/2018 12:23 pm
Hi Ryan, welcome to the Forum here!
I suppose that 3% less as well as 3% more than the value in D30 counts?
And exact 3% also?
See attached file for my solution.
Good luck!
Frans
Posted : 06/04/2018 2:34 pm
Topic starter
Excellent! Thank you Frans!
Posted : 10/04/2018 4:40 pm
