Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Appreciate your input. I was not exactly clear with
problem definition - I thind the <"" part interfered somehow. Anyway, thanks very much for your time. -----Original Message----- Phil Hageman wrote: This conditional formatting formula works when B30 has values entered (condition is true). When B30 has no data entered, I need a false condition, so no formatting occurs. What would the new formula be? =OR(B30=FinancialM17,B30<=FinancialM27) =IF(AND(B30<"",OR(B30=FinancialM17,B30<=Financi alM27))) Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula modification | Excel Worksheet Functions | |||
Formula Modification | Excel Discussion (Misc queries) | |||
Formula Modification | New Users to Excel | |||
Formula Modification Help | Excel Worksheet Functions | |||
Formula Modification | Excel Programming |