LinkBack URL
About LinkBacks
Help Please
I have 3 columns for dates
A1 (5 jan 13)
B1(15 jan 13)
C1( 25 jan 13)
D1 is emty cell
If A1 date is current date the empty cell should show green colour,if date is B1 show automatically yellow and if current date is c1 date it shows red
Conditional formating
Help Please
I have 3 columns for dates
A1 (5 jan 13)
B1(15 jan 13)
C1( 25 jan 13)
D1 is emty cell
If A1 date is current date the empty cell should show green colour,if date is B1 show automatically yellow and if current date is c1 date it shows red
Last edited by Adnan Haider; 05-31-2013 at 07:20 AM.
In conditional formatting rules
=TODAY()=A1 >>>GREEN
=TODAY()=B1 >>>YELLOW
=TODAY()=C1 >>>RED
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks