Cloror in a formula - with certain criteria

  • Thread starter Thread starter Farmer Ted
  • Start date Start date
F

Farmer Ted

Is there a way to make a color change if the result of the formula is above
or below a certain number OR result?
 
hi
yes. use conditional formating.
on the menu bar....
format>conditional formatting
condition1-if cell value is..less than..your number
pick your color
contition2-if cell value is..greater than..your number
pick your other color.
you might want to consider greater that or equal to.
less than or equal to..
regards
FSt1
 
Thanks. . .I knew it was a simple answer. . .I thought it would be better to
ask the question than spend hours tooling around myself. Thanks alot
 
you are welcome.
regards
FSt1

Farmer Ted said:
Thanks. . .I knew it was a simple answer. . .I thought it would be better to
ask the question than spend hours tooling around myself. Thanks alot
Click to expand...
 
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

Excel Need Countifs Formula Help 0
Access Dcount (multiple criteria) 3
Conditional Sum - variable criteria 5
Excel Copy & Paste Issue ?? 5
Excel VBA 1
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Additional formula 3
Excel Conditional formula for different scenarios 0

Back
Top