How to apply a conditional formula ?

  • Thread starter Thread starter SSVegetto
  • Start date Start date
S

SSVegetto

How to apply a conditional formula ? How do I apply a conditioanl
formula to column so if a number is above 12 then it will be green.
 
SSVegetto, select the column, format conditional formatting, cell valve is
greater than or equal to 12, click format and pick green for the font or
background color, OK, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
You probably want a conditional format, not formula?

Select the cell or range and click Format > Conditional Formatting.
Make selections to say Cell Value Is Greater than 12.
Click the little Format button. Go to the Patterns tab and click o
the yellow square. Click OK a couple of times.
 

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


Back
Top