Change the color of a cell or text with an if statement

  • Thread starter Thread starter Guest
  • Start date Start date
use conditional formating Fomat-conditonal formatting equation is (your
formula) and format as wanted
 
=IF(D6="Yes", "Complete", IF(F6>=$B$1, "Current", "Past Due"))

I want it to be red if "Past Due"

for the conditional I have Formula is ="Past Due"

but that does not work.

thanks
 
You have to add the address of the cell that contains the formula.

If your original formula is in A1, and A1 is what you're looking to turn
red, then select A1 when creating your CF, and your *conditional* formula
should be:

=A1="Past Due"
 
use formula is =F6<$B$1

It's the same condition that causes the IF() formula to return Past Due
 
redid my formula
=IF($B$1<F6,"Current",IF($B$1-7>F6,"7 Days Past Due", IF($B$1>F6,"Past
Due",unknown)))

I have added the 7 days past due, I would like to use two different colors,
one for past due and one for 7 days past due.

Thanks
 
Also is there a way to make more than one cell formated. I would like the
whole line to become red.
 
I am using

=$B$1-7<F6<$B$1 (yellow) but it is not working.
I also have:
=F6<$B$1 that is working (red)
 
in the conditional formatting window
click add to get new options
you can have up to three
use the <7 days as the first and past due as the second
it will do the first conditional format it meets.

select the entire row and put as condiotn 1 the formula is =$f6<$B$1-7
format as red
condition 2 the formula is =$f6<$B$1 format other yellow
Assuming f6 is the due date and b1 is todays date.
 
First condition (7 days past due)

=And($B$1>$F6,$B$1<=($F6+7)) - format yellow

Second condition

=$B$1>($F6+7) - format red

To make the whole row turn red (or yellow), select all the cells in the row
you want to be formatted this way AND THEN do the conditional formatting
 
Back
Top