% or Nr

  • Thread starter Thread starter Mickey
  • Start date Start date
M

Mickey

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
 
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:
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to add 3 column (of YES) to give a total % complete 7
conditional formating adjacent rows 4
Apply Conditional Formatting to other rows 6
Creating a formula relating to several cells 2
Formatting "IF" response based on "OR" function 5
IF AND question 2
Unable to obtain relative reference using conditional formatting 2
Formula help 0

Back
Top