[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • 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
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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