Conditional Formatting Question
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 |
Conditional Formatting Question
=AND(b180,c1=true,d15) , set color to red, etc.
|
All times are GMT +1. The time now is 01:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com