Hi All,
If there is a date after 01/01/2012 in column F, I want the cell in the same row colored in column A.
Thanks you for the help!
Hi All,
If there is a date after 01/01/2012 in column F, I want the cell in the same row colored in column A.
Thanks you for the help!
Last edited by NBVC; 02-14-2012 at 04:09 PM.
Under conditional formatting, select new rule...format only cells that contain...cell value...greather than...1/1/2012.
Select whatever color you want and "accept"
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I mentioned that this is Excel 2003; those options are for the later version. Can you help me write the formula? Thanks.
Select column A and go to Format|Conditional Formatting.
Select Formula Is from drop down and enter:
=$F1>DATE(2012,1,1)
where F1 corresponds to first cell selected in column A.
Click Format and choose from Pattern tab.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks very much; it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks