Fill Colour for an IF statement

[liamT]

I want to create an IF statement such that if the
condition is satisfied then the cell with the IF statement
will be filled in black. I know how to do IF statements
but not sure how to get the colour to fill the cell. Would
appreciate assistance

 

[JE McGimpsey]

Worksheet functions can only return values to their calling cells, not
change formatting. Instead, check out Conditional Formatting in XL Help.