Using the IF statment to specify cell color

garlicman

New Member
Joined
Jun 12, 2007
Messages
26
I'm sure this question has been asked before, but the search feature keeps timing out.

I wanted to know if it is possible to specify a cell color using the IF statement. I've used up all 3 of my conditional formats and I'm unfamiliar with Macros

Thanks Alot!
Love the site!
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
no you will have to have a macro. Post examples of your data and what you need and someone will help you work through it. :)
 
Upvote 0
The conditional format will be applied to column J

Cell J4=IF(CG4>0,0,IF(CG4>=-2%,1,IF(CG4>=-4%,2,IF(CG4>=-6%,3,IF(CG4>=-9.99%,4,IF(CG4<=-10%,5))))))

All 3 conditional formats are used

I would like for the cell (J4) to be filled with a different color if cell D4 contains "Private Company"

Hope this is clear, any help is greatly appreciated!
 
Upvote 0
Condition 1: Formula Is: =F4="yes" ---> cell turns red
Condition 2: Formula Is: =G4="yes" ---> cell turns red
Condition 3: Formula Is: =C4<1000 ---> cell turns red

something tells me i can combine these three into 1??
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,317
Members
448,564
Latest member
ED38

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