Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating for blank.
My formula is as follow:
L31=IF(OR(J31="",K31=""),"",(J31-K31)/J31). M31is the goal number. I set a conditional formatting that if L31 is less than M31 the cell is fill red and if L31 is greater than or equal to M31 it will be green. When J31 and K31 is blank, L31 is appear green. I have another formula. L43=IF(OR(J43="",K43=""),"",SUM(J43:K43)). I set some condtional formatting. However when J43 and K43 is blank, L43 turn appear as red. Why the difference? What I dont understand is |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating for blank.
Try this to correct L31's cond formatting ..
Select L31, then set the CF formulas/formats as: Cond1: =OR(L31="",M31="") Format: Leave it as "No Format set" Cond2: =L31<M31 Format: Red fill Cond3: =L31=M31 Format: Green fill For L43, your question was left hanging in mid-air? <g But think it'll work ok if you try something along the same lines as for L31 above I'd usually set it to trap for "" as the first condition before going into the other numeric conditions -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "chiuinggum" wrote: My formula is as follow: L31=IF(OR(J31="",K31=""),"",(J31-K31)/J31). M31is the goal number. I set a conditional formatting that if L31 is less than M31 the cell is fill red and if L31 is greater than or equal to M31 it will be green. When J31 and K31 is blank, L31 is appear green. I have another formula. L43=IF(OR(J43="",K43=""),"",SUM(J43:K43)). I set some condtional formatting. However when J43 and K43 is blank, L43 turn appear as red. Why the difference? What I dont understand is |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel conditional formating decimal fractions | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |