Hi, I'm new to this, so bare with me.
I have a bunch of laptops that regularily get signed out, anywhere between 1-14days.
I have a start date (B2) and return date (C2)... for example, Sign out is March 13, Return date is March 25
All I want is to have the sign out date go red when its due on that day.
So far I cannot find any google examples that meet my specific needs.
I'm trying conditional formatting in excel 2007 but I cannot figure out the string.
Thanks for help
Shane
=IF(C2>=Today()) in the conditional formatting rule, then formatted how you want.
Here is a useful link for help on understanding Conditional Formatting.
Excel Conditional Formatting -- Introduction
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks