if cell > 150 then colour = red else colour green

**genadi** · 08-30-2009, 01:44 AM

Hi,

Just trying to work out a formula to use in excel for:
if cell > 150 then colour = red else colour green

Basically, its for a budget and i have three cells that i want to fill with green if the value of that cell is less than $150 or fill the value of that cell with red if the value is greater than $150..

Some help please :D

**JBeaucaire** · 08-30-2009, 01:50 AM

This is conditional formatting (Format > Conditional Formatting).

The formulas I would use are:
Condition1: Formula Is: =AND(A1>0,A1>150)
Format... Patterns: Red color

Condition2: Formula Is: =AND(A1>0,A1<=150)
Format... Patterns: Green color

Of course, adjust the cell references to your actual cell(s)

**genadi** · 08-30-2009, 02:10 AM

Cheers mate

**JBeaucaire** · 08-30-2009, 02:15 AM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)