Previous Topic Next Topic

Excel IF formula

Closed
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.
Related:

1 response

Answer 1 / 1
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.
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response