I'm So confused-Need formula results to be different colors

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

Hi To All that read this, and Thank you in Advance. My
worksheet reads as follows:
Cell A1 + Cell B1 = 70.00 or less(I need this to be a
black color)

or if:
Cell A1 + Cell B1 = 70.25 or greater(I need this to be a
red color)

Please help I would be so grateful.
 
Denise

Use Format>Conditional Formatting to achieve this.

Assume your formula =A1+B1 is in cell C1

Select C1 and Format>CF>Cell Value is: less than or equal to: 70

Format as Black.

You can Add up to three conditions(four if you count the default color)

Gord Dibben Excel MVP
 
Back
Top