IF function with Conditional Formatting

[Dennisr53]

Hi everyone,

I am trying to create a formula that will look at the value( a number) in C29 and if it is larger than the value ( a number) in C31 then fill C29 with red, if the value is less then fill C29 with orange. I believe this can be done with the if function along with some conditional formatting. Any suggestions would be greatly appreciated. Thanks in advance for your help. =IF(C29<C31,"fill c29 red")+IF(C29>C31,"fill C29 orange") This is what I thought the formula might look like.

 

[Fishboy]

Hi everyone,

I am trying to create a formula that will look at the value( a number) in C29 and if it is larger than the value ( a number) in C31 then fill C29 with red, if the value is less then fill C29 with orange. I believe this can be done with the if function along with some conditional formatting. Any suggestions would be greatly appreciated. Thanks in advance for your help. =IF(C29<c31,"fill c29="" red")+if(c29="">C31,"fill C29 orange") This is what I thought the formula might look like.

Hi Dennisr53, welcome to the boards.

This should be fairly simple to achieve.

Select cell C29, go to conditional formatting and create a new rule.
Select the bottom option "Use formula to determine which cells to format"
In the formula bar type in =C29 > C31 (without the spaces)
Click the Format box and select the red fill.
Click OK

Now create a second new rule
Select the bottom option "Use formula to determine which cells to format"
In the formula bar type in =C29 < C31<c31
(without the spaces)
Click the Format box and select the orange fill.
Click OK

</c31
</c31,"fill>

 

[steve the fish]

You rarely need an IF function in conditional formatting. You are looking to create TRUE/FALSE answer. So something like =C29>C31

 

[Dennisr53]

Thanks a lot Fishboy. That worked like a champ. I guess I was overthinking what I wanted to do.

 

[Fishboy]

Thanks a lot Fishboy. That worked like a champ. I guess I was overthinking what I wanted to do.

You're welcome mate. Happy to help.

 

[Dennisr53]

Thank you for responding Steve the fish. You were thinking in the right direction but Fishboy had the solution that was simple and worked. Thanks again.