Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If statements in Excel 1

Status
Not open for further replies.
debful

debful

Technical User
Nov 10, 2002
46
AU
Hi, I am trying to set up an IF statement in Excel. All I want is for excel to check particular figues and if they fall below $3,000 then make the figure show up in red. All assistance appreciated.
 
Sort by date Sort by votes
Have a look at conditional formatting, under the formatting menu.
 
Upvote 0 Downvote
That was easy! Thank you. I have never noticed conditional formatting before!

Cheers
Debbie
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
281
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
281
combo
combo
shytott
  • Locked
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
849
shytott
shytott
renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
604
SoftwareRT
SoftwareRT
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
172
Andyri
Andyri

Part and Inventory Search

Sponsor

Back
Top