I am having trouble figuring out how to do the following...
I need a formula/conditional formatting to format a cell so that it highlights in a certain color when that cell is within 30% or 10% of another cell's value. I am working with currency values, if that information helps.
For example: Highlight N14 in orange when N14 is within 30% of the value in A15 ... and... highlight N14 in red when N14 is within 10% of the value in A15.
Thank you!!
Bookmarks