You can use conditional formatting to do this. When you bring up the
CF dialogue, choose Formula Is rather than Cell Value Is in the first
box, and put this formula in the next box:

=OR(AND(G100TODAY(),G101=0),AND(H100TODAY(),H101 =0),AND(i100TODAY
(),i101=0),AND(J100TODAY(),J101=0))

Click on the Format button, then the Patterns tab and choose orange,
then OK your way out.

Hope this helps.

Pete

On Nov 29, 5:51*pm, mjones wrote:
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