Solved

Excel: mark some cells red

Posted on 2011-09-27
6
164 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
using vb script 5 52
question on substitute function 2 27
Stop excel from formatting numbers 4 19
MS Excel duplicate input detect. 8 23
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

726 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