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 |
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) |