IF function with Conditional Formatting

Dennisr53

New Member
Joined
May 29, 2015
Messages
38
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.
 
Last edited:

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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>
 
Upvote 0
You rarely need an IF function in conditional formatting. You are looking to create TRUE/FALSE answer. So something like =C29>C31
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top