% or Nr
 

Hi,
I am trying to work out the following and would appreciate alittle help.

I want to set conditional formatting so that a cell changes colour whenever
A2=40 or A3=25% whichever is greater.

A1 = 100
A2 = 25
A3 = A2/A1 (formatted as %)

I'd appreciate any help,
Thanks,
Mickey

% or Nr
 

hi Mickey,

try to create the both conditions on the conditional format, as

1st condition is =40 foramat as you wish
2nd condition is =0,25 foramat as you wish

does this help?
regards from Brazil
Marcelo

"Mickey" escreveu:

Hi,
I am trying to work out the following and would appreciate alittle help.

I want to set conditional formatting so that a cell changes colour whenever
A2=40 or A3=25% whichever is greater.

A1 = 100
A2 = 25
A3 = A2/A1 (formatted as %)

I'd appreciate any help,
Thanks,
Mickey

% or Nr
 

Thx Marcelo,
I am trying to make it one formula so that I am sure the 'whichever is
greater' part is working.

Thanks again,
Mickey


"Marcelo" wrote in message
...
hi Mickey,

try to create the both conditions on the conditional format, as

1st condition is =40 foramat as you wish
2nd condition is =0,25 foramat as you wish

does this help?
regards from Brazil
Marcelo

"Mickey" escreveu:

Hi,
I am trying to work out the following and would appreciate alittle help.

I want to set conditional formatting so that a cell changes colour
whenever
A2=40 or A3=25% whichever is greater.

A1 = 100
A2 = 25
A3 = A2/A1 (formatted as %)

I'd appreciate any help,
Thanks,
Mickey

% or Nr
 

Hi. Mikey,
maybe the C person web page could help you

try:
http://www.cpearson.com/excel/CFColors.htm

regards
Marcelo



"Mickey" escreveu:

Thx Marcelo,
I am trying to make it one formula so that I am sure the 'whichever is
greater' part is working.

Thanks again,
Mickey


"Marcelo" wrote in message
...
hi Mickey,

try to create the both conditions on the conditional format, as

1st condition is =40 foramat as you wish
2nd condition is =0,25 foramat as you wish

does this help?
regards from Brazil
Marcelo

"Mickey" escreveu:

Hi,
I am trying to work out the following and would appreciate alittle help.

I want to set conditional formatting so that a cell changes colour
whenever
A2=40 or A3=25% whichever is greater.

A1 = 100
A2 = 25
A3 = A2/A1 (formatted as %)

I'd appreciate any help,
Thanks,
Mickey