I am trying to do a conditional format of an entire row based off one cell
but need to use a range of numbers. Example: If cell C7 is equal to 100% the
row is green, if it is less than 100% but greater than 95% it is yellow,
anything below 95 is red. I can get it to do two of those not all three. Any
ideas?