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