Conditional cell coloring

[Guest]

Is there a feature of function that will allow me to change the color of the
cell based on the value of another cell of the cell itself ?

I'm looking for a feature similar to the Conditional Formatting for text
color based on a value of a cell to change the text of a cell's color.

Regards

 

[Tom Ogilvy]

In conditional formatting, you can change the first dropdown from Cell Value
is to Formula Is, then enter a formula that describes almost any type of
condition/dependency you can think of (within reason). If it will be
applied to multiple cells, selective use of absolute and relative addresses
will ensure the proper conditions are observed in all the formatted cells -
entry is made with respect to the activecell in the multicell selection.

 

[JulieD]

Hi Wellie

this can be done via conditional formatting ... if you would like more
assistance please post your criteria and the cells that you want to apply
the formatting to.

 

[David McRitchie]

Hi Wellie,
For some more information on Conditional Formatting so that perhaps
you can answer yourself without having to post more information about
specific criteria.
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Keep in mind the cells to get colored is based on the selection

The formula for coloring each of those cells is based on the formula
relative to the active cell.

So if A1 is the active cell and you wanted to check the cell to the right
=B1=2
but if you want to color the entire row based on cell value in column B
=$B1=2


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm