Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |