The syntax for the OR function is shown in Excel help, just as is the syntax
for the AND function.

=OR(AND(G100today(),G101=0),AND(H100today(),H101 =0),AND(I100today(),I101=0),AND(J100today(),J101 =0))

Note that in this use, for conditional formatting, you don't need IF, as you
are merely lookimg for a TRUE or FALSE result.
--
David Biddulph

"mjones" wrote in message
...
Hi All,

Can I turn a cell’s contents orange

If G100today() and G101=0
Or
If H100today() and H101=0
Or
If I100today() and I101=0
Or
If J100today() and J101=0

This will help me not forget to pay my taxes when they are due - easy
to do with my crazy life.

I know how to do IF AND, but Not IF OR.

Thanks for any help,

Michele