Fill Colour for an IF statement

  • Thread starter Thread starter liamT
  • Start date Start date
L

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
 
Worksheet functions can only return values to their calling cells, not
change formatting. Instead, check out Conditional Formatting in XL Help.
 
Back
Top