View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mjones mjones is offline
external usenet poster
 
Posts: 86
Default Conditional IF Or Format

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