Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Conditional Formatting (If(Or(...)
0 views
Skip to first unread message
Maxwell
Dec 3, 2003, 5:33:57 PM12/3/03
to
How do you write and "OR" formula for conditional
formatting?
formatting?
In normal excel it would be something like this "=if(or
($A1=0,$A1<0),True,0)"
How would you do this in conditional format?
Jason Morin
Dec 3, 2003, 5:44:24 PM12/3/03
to
=OR($A1=0,$A1<0)
or shorter:
=$A1<=0
HTH
Jason
Atlanta, GA
>.
>
Aladin Akyurek
Dec 3, 2003, 5:59:50 PM12/3/03
to
=OR($A1=0,$A1<0)*($A1<>"")
"Maxwell" <anon...@discussions.microsoft.com> wrote in message
news:c6b701c3b9ed$8a3ae890$a601...@phx.gbl...
0 new messages