|If you are trying to eliminate the need for specific rules for specific values, why not put the Certification Period values in a specific row for each column and then reference that cell in your CF formula?|
I know this simple example won't apply to your exact situation, but the concept might still work.
Let's say I start with this:
The values I will use as the criteria for the CF are in G1:I1. In other words, these are the values that I will be comparing my data to.
The data that I want to CF is in G3:I4.
I want to CF any values in G3:I4 that are greater than the value in Row 1 of their respective column, as indicted by the asterik.
G H I
1 36 12 60
3 37* 11 61*
4 20 13* 59
I can select G3:I4 and apply this single CF Rule to the entire range:
In the example above, the CF was applied to G3, H4, and I3.
I hope that helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.