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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 2
Colour Fill 9
Collapsing all groups 0
Handling Dashes in IF statement 3
Using VLOOKUP to find colours 1
Change colour of cell if there is no value 4
Excel Conditional Formatting Removal 7
IF Statement - compare to coloured cell 7

Back
Top