So I've got two columns in excel. In column A, I have dollar amounts, and in column B, I have text, such as gas, grocery, etc. I want to shade column A a certain color depending on the corresponding value in column B (yellow for gas, red for grocery, etc). Any idea how to do this? I set the conditional formatting based on the formulas "IF(B1="gas", A1, A1)" and "IF(B1="grocery",A1,A1)" and set the shading to a different color. It worked for that cell, but when I copy it to another cell, it doesnt update the cell numbers. ie, when I use it on A2, it still evaluates it based on B1.
2006-09-01
11:49:59
·
5 answers
·
asked by
Manu
2
in
Software