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%

Use a threshold of less than 41%.

--
HTH

Bob Phillips

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

"Robojohn" wrote in message
...
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%

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.

"Bob Phillips" wrote:

Use a threshold of less than 41%.

--
HTH

Bob Phillips

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

"Robojohn" wrote in message
...
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%

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)

"Robojohn" wrote in message
...
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.

"Bob Phillips" wrote:

Use a threshold of less than 41%.

--
HTH

Bob Phillips

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

"Robojohn" wrote in message
...
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%

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

"Robojohn" wrote:

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.

"Bob Phillips" wrote:

Use a threshold of less than 41%.

--
HTH

Bob Phillips

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

"Robojohn" wrote in message
...
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%