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...
Maybe you can use the CountByFontColor function provided by kutools for excel
GEEK_21Thanks, I'm not familiar with that suite, but it sounds like that function will count how many cells are of a particular color. If that's what it does I don't think that will help me - I need to conditionally color cells based on a number, not count how many cells are already of a particular color. Could you please clarify how that function would help if I was to buy the tool suite?
GregP997 No, it works with the colour of the cell and for your case I think you will have to associate it with the function if
- 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?
