I understand how to to color either the cell background or just the text, but I have not come across an example with both conditionally colored as Excel can do.
My requirement is to color the cell based on a value range and then make the text red/black/white based on a different metric. Ideally, if I could just override the 'smart black/white' text with red once and a while that would be nice.
Any examples of conditionally formatting both text and cell background at the same time out there?