Excel IF formula

Bran82 Posts 1 Registration date Wednesday August 21, 2013 Status Member Last seen August 21, 2013 - Aug 21, 2013 at 01:09 PM
 Blocked Profile - Aug 21, 2013 at 02:55 PM
Haven't used Excel in quite some time so this is pretty beginner. I just want to make a formula that turns a cell a different color based on the date. Basically whatever date is in the cell if it has been over 180 days it goes to one color, over 365 it goes to another.

1 response

Blocked Profile
Aug 21, 2013 at 02:55 PM
Good Afternoon,

What version of Excel are you using?

You could use the built in function of conditional formatting. Have look at that.