Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Darla Morrison   on Aug 25 In MS Office Category.

  
Question Answered By: Janet Phillips   on Aug 25

I think you could use a conditional  format with a single condition of
something like:

=OR(D16<CHOOSE(B16,$D$65530-0.07,$D$65529-0.07,$D$65532-0.05,$D$65531-0.05),
D16>CHOOSE(B16,$D$65530+0.07,$D$65529+0.07,$D$65532+0.05,$D$65531+0.05))

Change the specifics as you need them, since your two examples had
different lists of conditions...

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Conditional Formatting Or Select Case Or get search suggestion and latest updates.


Tagged: