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: Jacob Bouchard   on Aug 25

The problem with what you are describing (or at least what I think you are
describing - it's very vague) is that your conditional  formatting formula is
going to have to look at B3 and make the same decisions that your main
formula has already made. While this is perfectly possible, it's
cumbersome.

You should really bring your selected limits up onto row 3 as upper/lower.
Then it's easy enough to compare the value against your upper and lower
limits in your conditional formatting  statement.

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: