Automate Cell colors??

  • Thread starter Thread starter Freightdog
  • Start date Start date
F

Freightdog

Hello all,
I just spent some time looking thru this group and the depth of knowledge is
amazing. Thanks to all who unselfishly offer their help and expertise.

I would like to know if it is possible to have a cells background color
change depending on a value selected by the user.

This spreadsheet is being use for some aviation related calculations.
Depending on the Aircraft type selected by the user a particular value shown
in a cell will either be added or subtracted. If the value is being added I
would like the cell color to be, say, green. If the value needs to be
subtracted I would like the cell color to be red.
Is this type of automatic formatting possible??

thanks so much to all

glen
 
Take a look at Format / Conditional Formatting which will allow you 3 possible
formatting options, or 4 if you include the default colour. Post back with a
few more details about how you would differentiate between a value that should
be added or subtracted and we can give you a bit more guidance, ie how many
aircraft types etc
 
thanks guys....
i'll take a look at those links...

Ken,
to answer your question. Depending on the aircraft type selected a weight
correction is required that may either add allowable weight or subtract
allowable weight.
There are three different types of aircraft...
B-757 With Pratt and Whitney Engines
B-757 With Rolls Royce engines
B-767 With GE Engines.

As an example, selecting B-757 With Pratts would ADD allowable weight for
climb given a specific altimeter setting. However if we select the 757 RR or
767GE we would need to subtract allowable weight for that same altimeter
setting. For whatever aircraft is selected, the value will appear in the
same cell. I just want the user to be able to look at the cell to know if
the value is being added or subtract dependant on the cell color (in
relation to the aircraft selected and altimeter setting, formulas for which
I can figure out....)

hope that clears things up a bit...

thanks again guys

glen
 
Then you can use Format / Conditional Formatting.

Click on the cell that will contain the value and do Fomrat / Cond Formatting -
Change 'cell value is' to 'Formula is', use the range selector to clcik on the
cell that will contain the value B-757......., and then type ="B-757...."

This means for instance that if the cell containing the airplane was cell A1,
you would now see the following in the formula box:-

=$A$1="B-757 With Pratts"

You then hit the format button and choose the appropriate format for the cell
with the value in it if that condition is evaluated as being true, ie if A1 is
that aircraft. Then hit add and put in the other two conditions for the other
aircraft.
 
Most excellent Ken...
thankyou so very much....
you've saved me hours of work...
take care
glen
 
Back
Top