Conditional Formatting

[Fredilev]

I previously asked how to do IF statements for multiple cells. The second part of my question is how to apply conditional formatting to that cell. So....
If I'm using the following formula: =IF(AND(E13>=6.5,E14>=6.5,E15>=6.5,E16>=6.5),"Meets Criteria","Does Not Meet Critera") How can I have the cell be pink if "Does Not Meet Criteria" appears and green if "Meets Criteria" appears?

Thanks.

I can help with cooking questions, it's just excel that confuses me.

 

[T. Valko]

I previously asked how to do IF statements for multiple cells. The second part of my question is how to apply conditional formatting to that cell. So....
If I'm using the following formula: =IF(AND(E13>=6.5,E14>=6.5,E15>=6.5,E16>=6.5),"Meets Criteria","Does Not Meet Critera") How can I have the cell be pink if "Does Not Meet Criteria" appears and green if "Meets Criteria" appears?

Thanks.

I can help with cooking questions, it's just excel that confuses me.

What version of Excel are you using?

What cell is that formula in?

 

[Fredilev]

Excel 2008 for Mac; version 12.2.9
Cell E17

 

[T. Valko]

Excel 2008 for Mac; version 12.2.9
Cell E17

Well, I don't know if Mac Excel and PC Excel are the same (I use PC Excel) so I'll have to pass.

Maybe someone that uses a Mac will stop by and be able to help.

 

[Fredilev]

Thanks for trying!

 

[pedie]

Maybe select/try thi navigation and formula
Home tab > conditional fomatting > new rule > Use a formula to determine which cell to Format > enter a formula =AND(E13>=6.5,E14>=6.5,E15>=6.5,E16>=6.5)
then click on format > fill tab > select the color hit OK

 

[Fredilev]

I think I know what the issue is -- Once the IF is taken out then the formula needs to be modified.

If any of the cells is <6.5 it has to be pink, only if all are >=6.5 should the cell be green.