Conditional formatting question. I know how to create a rule to format a certain cell to fill green when a certain date is reached within that cell, but how to you do it when another cell reaches that date? For example, I want cell A1 to fill green when cell C1 reaches the date contained within.
I googled it and came up with this: http://www.techonthenet.com/excel/questions/cond_format4_2007.php which is how I learned how to fill a cell on a date, but no examples of what I am looking for.
I googled it and came up with this: http://www.techonthenet.com/excel/questions/cond_format4_2007.php which is how I learned how to fill a cell on a date, but no examples of what I am looking for.