Nesting cell fill colours within an "if" statement

[Kenjoh999]

Hello All,

I have an if statement in a cell g133, for example

=IF(B127>=1,"Fail",IF(C135>85%,"pass","fail"))

It works fine but i would like to fill cell g133 with a background colour subject to outcome of the if statement.

Cell b127 contains a number of "totally un-acceptable failures", so working on a traffic light system, if it true then the background should be filled "RED" and with the word fail

Assuming that b127 is false, we move onto the second part of the if statement.

Cell C135 contains % pass mark. If it greater than 85%, it returns the word "pass" with a green fill colour, if not I need it to return the word "fail" with an "AMBER" fill colour.

To be fair C135>85%, should probably have a greater than or equal to but I can work that, would just like to have advice how to create the colour fills

kenny

[TMS]

You’d use Conditional Formatting with different CF Formulae

=B127>=1 format red
=AND(B127<1, C135>85%) format green
=AND(B127<1, C135<=85%) format amber