Using IF Function

  • Thread starter Thread starter Old Red One
  • Start date Start date
O

Old Red One

If the number in B1 is greater than the number in A1 and the word to appear
is INVERTED then =IF(B1>A1,"INVERT","NORMAL") works in C1. How can I format
cell C1 so that it is red for INVERT.
 
Take a look at Format|conditional formatting.

You can change the format based on the value in the cell.
 
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

editing cel 2
Excel 2007 and inverted charts 1
inverting data and multiplication 0
somewhat complicated conditional formula 2
Cell colour change if formula displays false 3
Seperating and extracting text from parentheses 2
Seperating and extracting text from parentheses 4
Acer 5734Z lap top,how many volts should be there inverter board voltage AC or DC ? 0

Back
Top