|
|
#9
03-25-2012, 09:59 AM
|
|||
|
|||
You said the CF formula works when there is a $ in it.
The dollar sign means to always use that column (or row) for the comparison. It sounds like you want to use a different CF formula in other columns? I'm not sure where you are with your question now. I hope you understand the $ in the formula. If not a very simple explaination can be found at http://www.homeandlearn.co.uk/excel2...l2007s7p5.html 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional formatting | zanat0s | Excel | 4 | 01-20-2012 03:30 AM |
 Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
|
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
| Conditional Formatting Problem Excel 2007 | namedujour | Excel | 6 | 08-04-2011 10:52 AM |
|
help with conditional formatting
|
Snvlsfoal | Excel | 3 | 07-03-2011 11:55 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode