Conditional Formatting Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

In cell f11:

=if(e11+g11>d11,="color yellow",if(e11+g11<d11,="color
blue",if(e11+g11=d11,="color red")

How can I do something like this? I want cell f11 to change to yellow
blue or red if the conditons are met.

I also need it to fill down as I input data day to day.

I tried going into home>styles>conditional formatting, but I'm missing
something to make it all work.

Thanks
 
In cell f11:

=if(e11+g11>d11,="color yellow",if(e11+g11<d11,="color
blue",if(e11+g11=d11,="color red")

How can I do something like this?  I want cell f11 to change to yellow
blue or red if the conditons are met.

I also need it to fill down as I input data day to day.

I tried going into home>styles>conditional formatting, but I'm missing
something to make it all work.

Thanks
Click to expand...

Jim,

Starting at cell f11 highlight all the cells you want the formats
applied to.
Then open up the conditional formatting window.

Change 'Cell Value is' to 'Formula is' and enter

=(E11+G11)>D11
and set the format to YELLOW

click on ADD and repeat twice with your other formulas and format
colours

Regards

David
 
Thanks, much appreciated.

Jim,

Starting at cell f11 highlight all the cells you want the formats
applied to.
Then open up the conditional formatting window.

Change 'Cell Value is' to 'Formula is' and enter

=(E11+G11)>D11
and set the format to YELLOW

click on ADD and repeat twice with your other formulas and format
colours

Regards

David
Click to expand...
 
Back
Top