conditional format data bars based on different cell
Posted on 2010-09-20
I want to use conditional formatting with data bars based on the value of a different cell. The cell to show the data bar is a text cell in the same row as the cell with the value. ie; cell D14 contains the item description and cell X14 contains the amount. I want the data bar in the cell with the description based on the value in X. Possible?