can conditional formatting depend on the value of another cell?
Posted on 2012-08-24
I would like to have my age in column A.
I would like to have my savings account in column B. It is an interest-bearing account that changes with my age.
I would like to have the color of both columns depend upon how old I am. Thus, when I'm in my 40s-the color of both columns is green. When I am in my 50s, the color of both columns is blue. Etc.
I'm having trouble getting the cells in column B to depend upon the value of the cells in column A. Is this possible?