View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] jesoldano@gmail.com is offline
external usenet poster
 
Posts: 31
Default Conditional If Statements

Hello--I am a novice with respect to conditional if statements. I
would like to express the following in a formula:

If cell A =5 AND cell B2, return Red
If cell A<=5 AND cell B=0, return Green
If cell A=5 AND cell B=0 OR Cell A<=5 AND cell B=2-5, Return Yellow.

I know this is a lot. What I would like to know is whether it is even
possible to include this many conditions.

Thanks!