Hello,

I am trying to format a cell (let's say A:1), as either green, amber,
or red. It should be based on the values in other cells (B:1, C:1, and
D:1).

I want A:1 to be green if B:180, and C:1=True, and D:15.

I want A:1 to be red if B:1<=80, and C:1=False, and D1<=4.

I want A:1 to be amber if either B:1 <=80, C:1= False, or D:1<=4.

Anyone have an idea of a formula I can use? I can't seem to get my
IF's and my parentheses lined up in a workable format.

Thanks!


--
mwevans1234
------------------------------------------------------------------------
mwevans1234's Profile: http://www.excelforum.com/member.php...o&userid=34767
View this thread: http://www.excelforum.com/showthread...hreadid=545267

=AND(b180,c1=true,d15) , set color to red, etc.

Wrote:
=AND(b180,c1=true,d15) , set color to red, etc.

Thank you so much! (My boss says thank you, too) :)


--
mwevans1234
------------------------------------------------------------------------
mwevans1234's Profile: http://www.excelforum.com/member.php...o&userid=34767
View this thread: http://www.excelforum.com/showthread...hreadid=545267