|
|
|
|
#1
07-03-2012, 04:20 AM
|
|||
|
|||
How-TO format cells (FILL) by comparing cells
Hi,
I need some help. I have 2 columns : sales of 2011 and sales of 2012.. I want to find HOW to Format the cells by comparing lets say A2 to B2. If A2>B2 then Fill the cell with Green and the text with Red color. how is that possible? 
|
|
#2
07-03-2012, 04:27 AM
|
||||
|
||||
|
You can use conditional formatting. See:
http://www.free-training-tutorial.co...ormatting.html http://www.cpearson.com/excel/cformatting.htm http://dmcritchie.mvps.org/excel/condfmt.htm
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word]
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel 2010 Format cells to use as Gantt or Plan | Kizzie | Excel | 0 | 12-13-2011 02:31 AM |
| How can I fill the below emty cells with above cell data? | Learner7 | Excel | 8 | 06-28-2011 12:10 PM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
| format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |
| Automatically entering/fill data in cells in Excel 2003 | dipdog | Excel | 0 | 08-17-2006 08:37 AM |
How-TO format cells (FILL) by comparing cells
Windows 7 64bit 
Office 2007
Hybrid Mode