Solved

Excel: mark some cells red

Posted on 2011-09-27
6
160 Views
Last Modified: 2012-05-12
In excel, how would I make the contains of a cell red if its contents are > 0?
E.g. if I have some cells like so:

1
-1
2
-4
5

I would like the 1, 2, and 5 to be red.

0
Comment
Question by:allelopath
  • 3
  • 3
6 Comments
 
LVL 24

Expert Comment

by:StephenJR
ID: 36711084
Use conditional formatting. Formula =A1>0

For precise details, state which version of Excel you are using.
0
 
LVL 1

Author Comment

by:allelopath
ID: 36711087
2003
0
 
LVL 24

Accepted Solution

by:
StephenJR earned 500 total points
ID: 36711093
Not even that complicated, just use value >0 and choose formatting as red.

Excel 2003

http://www.contextures.com/xlcondFormat01.html
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 1

Author Comment

by:allelopath
ID: 36711134
Sorry, I mispoke. I am actually using Excel 2007, but saving as 2003 (.xls).
0
 
LVL 24

Expert Comment

by:StephenJR
ID: 36711182
It's pretty much the same in 07, via the Home tab I believe.
0
 
LVL 1

Author Comment

by:allelopath
ID: 36711211
oh, got it. thanks.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now