Conditional formatting excel for mac

broken image
broken image

Is this possible?Īnswer: If you wish to change the color of the font based on the value in a cell, you will need to apply conditional formatting.

broken image

If the sum is less than 10, I would like the sum to be the color blue. If the sum is greater than 10, I would like the sum to be the color red. Question: In Microsoft Excel 2011 for Mac, I'm putting the sum of 3 cells in a 4th cell.