I am trying to highlight a cell in column B if it is +/- 5% of the value in column C. So if column C is 100 and in column B i enter 94 or less or enter 106 or more it turns red. Thanks for any help.
I am trying to highlight a cell in column B if it is +/- 5% of the value in column C. So if column C is 100 and in column B i enter 94 or less or enter 106 or more it turns red. Thanks for any help.
Try
=OR(B2<C2*0.95,B2>C2*1.05)
Works great, thanks!
You're welcome & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks