Conditional formula

[lothianred]

Hello

I am a new user to Excel but finding it a fantastic programme and wan
to learn more. I am trying to work out a conditional formula but a
having difficulty.

I want to enter a date in a cell, after 30 days I want to change th
colour of the font to yellow and after 60 days change it to red.
appreciate for most advanced users this is probably a simple formula
but for a newcomer like me it's proving problematic.

I have managed to work out how to change it once after 30 days, bu
can't seem to work out how to change it again after 60.

Any advice would be greatly appreciated

 

[Spencer101]

Hello

I am a new user to Excel but finding it a fantastic programme and wan
to learn more. I am trying to work out a conditional formula but a
having difficulty.

I want to enter a date in a cell, after 30 days I want to change th
colour of the font to yellow and after 60 days change it to red.
appreciate for most advanced users this is probably a simple formula
but for a newcomer like me it's proving problematic.

I have managed to work out how to change it once after 30 days, bu
can't seem to work out how to change it again after 60.

Any advice would be greatly appreciated.

You can add more than one conditional format to a cell. So you just d
the same as you did to get the 30 day change but a second condition fo
60 days.

Let me know if you need more help