Using the IF statment to specify cell color

[garlicman]

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!

 

[texasalynn]

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.

 

[garlicman]

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!

 

[texasalynn]

so what are the 3 conditional formats you currently use?

 

[garlicman]

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??

 

[garlicman]

any help is appreciated.

 

[texasalynn]

to combine those

=OR(F4="yes",G4="yes",C4<1000)