colour in formats

M

Martin

I have been reqeusted to produce a spreadsheet to which a cell will have
a three digit positive number (but can be text or even a formula if
needed) in it such as 747. I need the contents of this cell to change
colour depending on the results of a formula in another cell. (Is one
cell smaller, equal to, or larger than another cell). Red if negative.
Blue if 0. Green if positive. Can somebody please help me with this

Thanks
Martin :confused:
 
J

JE McGimpsey

Take a look at "Conditional Formatting" in XL Help.

For example: Select your cell (say, A1 which should be colored based on
cell B1). Set the dropdowns and textboxes to read:

CF1: Formula is =A1<B1
Format1: <font>/<red>

CF2: Formula is =A1=B1
Format2: <font>/<blue>

Format A1's font as green.
 

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

Question about conditional formatting of zeros in Excel 0
conditionally formatting colour of cells 2
Cell colour in relation to IF results 2
Conditional formatting in Excel 2010 2
Changing Celll colour as a result of a calculation 2
Fill Colour problem 2
Using CF to change colour in cell based on date? 4
Data Validation/Conditional Formating 3

Top