I have a spreadsheet that I have created and I need the dates entered to flag red if they are less than or equal to 30 days from today's date. I entered the conditional cell value of =TODAY()+30 and it flags red like I need it to. The problem now is that all cells in that column that are blank flag red. I would like them to stay the original color when blank. I have attached the file. The column is called "Release Date". Any help would be much appreciated, thanks in advance.
Last edited by abberoth; 07-19-2011 at 06:48 PM. Reason: Mark solved
You can use a formula as your rule: =AND(J7<>"",J7<=TODAY()+30)
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
That did it. You're awesome! Thanks a ton. BTW love your signature.
No worries. Please mark the thread solved if you're happy with the solution.
DomIf your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks