I need conditional formatting to apply to maximum %

R

Robojohn

Working in Excel, I have a formula which works out a percentage.
This percentage needs to be 40%, at which time the formatting will kick in.
However, one of the figures i enter can vary by £3 and still the result is
40%, due to decimal places.
I need the conditional formatting to come into play when the value is set to
the maximum amount possible before changing to 41%.
ie
payment 12,000
Charge 4799
total 40%
or
payment 30,000
Charge 7334 or 7335 or 7336
total 40%
 
B

Bob Phillips

Use a threshold of less than 41%.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Robojohn

That would be fine, however as i'm not showing decimal places it gets
complicated.
It has to be exactly 40%, but i muct be showing charges at the maximum
amount possibly which still shows 40%.
If there is a way of doing this without conditional formatting that may be
easier.
 
B

Bob Phillips

Then I am not getting it. one minute you say must be exactly 40%, then you
say upto 41%.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
R

Robojohn

12000 - typed in A1

4751 - typed in A2

format A3 as a % with no decimal places, then add the formula- =sum(A2/A1)

then try changing the 4751, keeping the % at 40%
you will see that you can alter the figure and it stays at 40.
i need A2 to be set to the very maximum amount which still shows 40%, at
this point i want the conditional formatting to highlight its right
 
Top