how to autoformat cell based on certain conditions

T

Tiffany

hi,

i have switched from excel xp to excel 2007. How to format the cell based on
certain conditions. e.g.

Brand % chg
A 10.0
B -10.0
C 20.0

For % chg column, i want to highlight the whole cell in red if it is negative.

Kindly advise.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set color for text based on conditions? 2
Cell is colored(red0....based on this how to change other cell val 1
Change Text Color in one cell based upon entry in referenced cell 3
How do I format a cell based on conditions in five different cells 1
Conditional formatting, based on a different cell? 3
Code to send a email via Macro in excel 1
Array - Count based on 3 conditions 1
Excel If a Cell Contains a Certain Text (From Another Table) 0

Top