Forum Discussion
Conditional formatting - color bars based on values in other cells
Hi guys, How would I apply color bar formatting to a range of cells, with that formatting based on the value of a different range of cells? I have several cells containing text, and I w...
OK well I'm not really sure how to do any of that. I've never used or heard of that function or tool suite, and don't know how it would need to associate with the IF function to get the result I want. Perhaps you could provide an example of what I'd need to do please?
if the font color of cell A1 is red and its value is equal to or more than 10 so B2 displays "good" and if its value is less than 10 then it displays "false".
- Thanks but as I said that's not the behavior I'm looking for. As I said, I am wanting Excel to color the cells for me based on a value in a different cell, they won't already be in a particular color. Otherwise I could just manually highlight the cells with whatever color I wanted and that would be the end of it. I'm just trying to use conditional formatting rather than shading them all manually.