View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default conditional formatting formula not working

You left out what you want if U449 is empty. Try this:
=IF($U$449<"","Maximun Discount 50%","")
HTH Otto
"Wanna Learn" wrote in message
...
Hello
In cell AC449 I have the following conditional formatting formula is
=IF($U$449<"","Maximun Discount 50%"). In plain english if cell u449 is
empty then nothing if cell u449 has any percent value in the cell , then
cell AC449 should say "Maximun Discount 50%" . My formula does not work
thanks in advance