View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default conditional formatting formula not working

Don't use CF!

Place this formula directly *IN* AC449:

=IF($U$449<"","Maximun Discount 50%","")

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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