formatting issue

  • Thread starter Thread starter Joyce
  • Start date Start date
J

Joyce

Can anyone please help me with the following problem. I
have a worksheet where one of the columns is a number of
days until a loan matures. there is already a date
function in the cell +DAYS360(a1:d5) I want to make it so
that if the number of days is between 61 and 99, then the
font is changed to green, if between 31 and 60, font is
blue and if between 1 and 30, font is red.

Help :)

Thank you very much.
Joyce
 
-----Original Message-----
Can anyone please help me with the following problem. I
have a worksheet where one of the columns is a number of
days until a loan matures. there is already a date
function in the cell +DAYS360(a1:d5) I want to make it so
that if the number of days is between 61 and 99, then the
font is changed to green, if between 31 and 60, font is
blue and if between 1 and 30, font is red.

Help :)

Thank you very much.
Joyce
.
Click to expand...

Go to Format, Conditional Formatting. It's pretty self
explanatory from there on. I believe you are limited to 3
conditions with this though.
 
With three different conditions, you can use conditional
formatting. With a cell selected click format then
conditional formatting... the dialog is pretty straight
forward from there...
 
Back
Top