Avatar of gacto
gacto asked on

Conditional Formatting

I cannot get conditional formatting in Excel 2010 to work on this formula.

=IF(TODAY()-F73<10,"",TODAY()-F73)

I have this formula entered to calculate the number of days that have passed since the last event. What I need is conditional formatting to highlight the cell where this formula is if the result of the formula is >29. So anything event that is 30 days past or more should be formatted.

When I try the conditional formatting in Excel every cell is highlighted even if the result of the formula above is less than 30. I know there is something screwy about conditional formatting and formulas but I cannot remember and I have not been able to get this to work.
Microsoft Excel

Avatar of undefined
Last Comment
gacto

8/22/2022 - Mon
andrew_man

Post your sheet here
ASKER
gacto

Here is a copy of what I am trying to make work. I just used the basic conditional formatting function here but I have tried several times to use other options and all of the results are the same.
ConditionalFormattingExample.xlsx
andrew_man

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Rob Henson

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
andrew_man

I suggest that not yet due to be zero instead of ""

=IF(TODAY()-F2<10,0,TODAY()-F2)
Rob Henson

I was thinking the same but left it with user's original.

If you use andrew_man's suggestion you can then use sheet options to hide zeros or Custom Format specific column so that they don't show.
andrew_man

Yes
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
gacto

andrew_man,

the spreadsheet you uploaded works fine until I enable editing and then the formatting fails. I have followed the logic of your formatting and it does not work in my version of Excel.
ASKER
gacto

Excellent suggestion Rob H.