Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, then formula with conditional formating
IF(D4<=(E4*4),"OK","NOT OK")
D4 E4 182 41 this returns NOT OK (41*4 = 164) 182 is not <=164 Can I write this as a conditional formating formula? Return the answer (164) but change the font color it if it does not meet the OK criteria. Thanks in advance! I'm learning a lot reading this discussion group! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, then formula with conditional formating
Write the following formula in the conditional formatting condition window:
=FALSE(A1) assuming the cell whose value you're looking to test is A1. Change to suit your needs. This tests if the condition is FALSE. If it is true that it is false (confusing) then it will apply the format you need. -- Brevity is the soul of wit. "Rex" wrote: IF(D4<=(E4*4),"OK","NOT OK") D4 E4 182 41 this returns NOT OK (41*4 = 164) 182 is not <=164 Can I write this as a conditional formating formula? Return the answer (164) but change the font color it if it does not meet the OK criteria. Thanks in advance! I'm learning a lot reading this discussion group! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, then formula with conditional formating
=false(D15<=(E15*4) Did not work. Left the font color black. Tried the
formula in the conditional formating window. What am I doing wrong? Can I have a formula in the cell to compute E15*4 and a conditional format. "Dave F" wrote: Write the following formula in the conditional formatting condition window: =FALSE(A1) assuming the cell whose value you're looking to test is A1. Change to suit your needs. This tests if the condition is FALSE. If it is true that it is false (confusing) then it will apply the format you need. -- Brevity is the soul of wit. "Rex" wrote: IF(D4<=(E4*4),"OK","NOT OK") D4 E4 182 41 this returns NOT OK (41*4 = 164) 182 is not <=164 Can I write this as a conditional formating formula? Return the answer (164) but change the font color it if it does not meet the OK criteria. Thanks in advance! I'm learning a lot reading this discussion group! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, then formula with conditional formating
Got it. Thanks.
"Rex" wrote: IF(D4<=(E4*4),"OK","NOT OK") D4 E4 182 41 this returns NOT OK (41*4 = 164) 182 is not <=164 Can I write this as a conditional formating formula? Return the answer (164) but change the font color it if it does not meet the OK criteria. Thanks in advance! I'm learning a lot reading this discussion group! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if, then formula with conditional formating
Urghh..... It doesn't work. It conditional formats all of the cells.
"Rex" wrote: =false(D15<=(E15*4) Did not work. Left the font color black. Tried the formula in the conditional formating window. What am I doing wrong? Can I have a formula in the cell to compute E15*4 and a conditional format. "Dave F" wrote: Write the following formula in the conditional formatting condition window: =FALSE(A1) assuming the cell whose value you're looking to test is A1. Change to suit your needs. This tests if the condition is FALSE. If it is true that it is false (confusing) then it will apply the format you need. -- Brevity is the soul of wit. "Rex" wrote: IF(D4<=(E4*4),"OK","NOT OK") D4 E4 182 41 this returns NOT OK (41*4 = 164) 182 is not <=164 Can I write this as a conditional formating formula? Return the answer (164) but change the font color it if it does not meet the OK criteria. Thanks in advance! I'm learning a lot reading this discussion group! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Changing a Formula in Conditional Formatting | Excel Worksheet Functions |