Conditional Formatting Question

M

mwevans1234

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:1>80, and C:1=True, and D:1>5.

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!
 
Top