Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 171
  • Last Modified:

Excel: mark some cells red

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
allelopath
Asked:
allelopath
  • 3
  • 3
1 Solution
 
StephenJRCommented:
Use conditional formatting. Formula =A1>0

For precise details, state which version of Excel you are using.
0
 
allelopathAuthor Commented:
2003
0
 
StephenJRCommented:
Not even that complicated, just use value >0 and choose formatting as red.

Excel 2003

http://www.contextures.com/xlcondFormat01.html
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
allelopathAuthor Commented:
Sorry, I mispoke. I am actually using Excel 2007, but saving as 2003 (.xls).
0
 
StephenJRCommented:
It's pretty much the same in 07, via the Home tab I believe.
0
 
allelopathAuthor Commented:
oh, got it. thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now