Conditional Formatting Question

[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

 

[David Heaton]

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

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

 

[JimS]

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