| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
% 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
% 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
