I want to apply conditional formatting to a cell so that it is filled in red if the value is above a set value (9.6). Easy enough. However, when using the "Greater Than" condition, the cell is formatted if it has no value entered. How do I stop this happening?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
A Nice Easy One (Hopefully!)
- Thread starter Mr Nick
- Start date
Aladin Akyurek
MrExcel MVP
- Joined
- Feb 14, 2002
- Messages
- 85,210
> It contains a formula:
=IF(G12="","",IF(G12="FIXED POWER",SUM(((T12*C12*K12)/1000)+U12),IF(G12="LIGHTING",SUM(((T12*C12*K12)/1000)+U12),IF(G12="RING MAIN",SUM(((T12*C12*K12)/4000)+U12),"Cct Type!"))))
Although unrelated to your question, how about using this shorter formula instead:
=IF(G12="","",IF(OR(G12={"FIXED POWER","LIGHTING"}),((T12*C12*K12)/1000)+U12,IF(G12="RING MAIN",((T12*C12*K12)/4000)+U12,"Cct Type!")))
Aladin
=IF(G12="","",IF(G12="FIXED POWER",SUM(((T12*C12*K12)/1000)+U12),IF(G12="LIGHTING",SUM(((T12*C12*K12)/1000)+U12),IF(G12="RING MAIN",SUM(((T12*C12*K12)/4000)+U12),"Cct Type!"))))
Although unrelated to your question, how about using this shorter formula instead:
=IF(G12="","",IF(OR(G12={"FIXED POWER","LIGHTING"}),((T12*C12*K12)/1000)+U12,IF(G12="RING MAIN",((T12*C12*K12)/4000)+U12,"Cct Type!")))
Aladin
Upvote
0
Excel Facts
Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
