Excel Conditional Format Issue

[Tara Monson]

Re: Excel Conditioning Format Issue

And what's boggling me is the second tab, "maintenance" works just fine.

 

[Steve Prevette]

Re: Excel Conditioning Format Issue

If you go to the rules manager, your cell ranges for application of the rules are conflcting.

 

[Tara Monson]

Re: Excel Conditioning Format Issue

Thanks Steve. Even if I delete all rules and start over with just ONE rule, It's turning all cells color...instead of just those 30 days out. See attached.

I'm so frustrated, i'm just tempted to start a new spreadsheet?

 

[Steve Prevette]

You have to get the rid of the quotation marks in the NOW() + 60. Bill Gates in his infinite wisdom adds them automatically, you've got to go in and delete then in the conditional rule.

 

[Tara Monson]

AH!

That WILEY BILL!

THANK YOU STEVEN. I will refrain from throwing my computer...until next time.

Thanks so much for your help!

 

[Tara Monson]

What's strange, is when I type in a rule, I do not put those quotes. But when I select the applicable range, they automatically appear and i have to go delete them.

Oh Mr. Gates. That's not cool.

 

[Statistical Steven]

Re: Excel Conditioning Format Issue

True,
And Tara can use the "Stop if True" condition. Arrange the conditions as follows
<60 (stop if true)
<30 (stop if true)
<0 (stop if true)

That is not really needed since you can specify between two times....