Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting formula not working
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting formula not working
Sorry. Missed the CF part. You can't use CF this way. CF changes the cell
format if a specific value is entered. It doesn't change the value/entry in any cell. In what cell do you want what? 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting formula not working
Conditional formatting is used to format the cell based on the cell value or
on the result (True or False) of any logical formula. Just enter the following formula in cell AC449 to get what you want =IF($U$449="","","Maximun Discount 50%") This will show Maximun Discount 50% in the cell when U449 is not empty... You should use ISNUMBER if you just want to check for numbers in U449 =IF(ISNUMBER(U449),"Maximun Discount 50%","") =================== Click 'Yes' if this helped. "Wanna Learn" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in VBA not working | Excel Discussion (Misc queries) | |||
Conditional Formatting Formula Not Working | Excel Worksheet Functions | |||
Conditional Formatting ROW not working | Excel Discussion (Misc queries) | |||
Conditional formatting: formula not working on other pc's | Excel Discussion (Misc queries) | |||
Conditional Formatting is not working... | Excel Worksheet Functions |