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

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
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

garlicman

New Member
Joined
Jun 12, 2007
Messages
26
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

garlicman

New Member
Joined
Jun 12, 2007
Messages
26
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,190,689
Messages
5,982,310
Members
439,772
Latest member
KimPhoenixT

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
Top