Good Morning,
My issue is I have a column with a due date and a column with a completion date, I would like for the column with the due date to show red if it is after today, but if there is a date in the completion column than it will continue to show green. I can get the formatting for the part to show red if it is over due, but I can't get the formatting to clear if there is a completion date in the next column.
Help, thanks!
Perhaps in Conditional Formating rules.
=and(a1>today(),b1>0)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
I did this and won't I need them separate? One for the red and one that shows true? I did this and nothing changed with my columns.
I suggest to upload a small sample workbook and be sure that someone will give you your solution
To attach a small sample workbook.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks