How_Do_I
Well-known Member
- Joined
- Oct 23, 2009
- Messages
- 1,843
- Office Version
- 2010
- Platform
- Windows
I can’t get this working…
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I want the 5 rows in a column to be highlighted if the top of the column DOES NOT = E1
<o> </o>
How would I do that with conditional formatting please?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I want the 5 rows in a column to be highlighted if the top of the column DOES NOT = E1
<o
> </o>How would I do that with conditional formatting please?
| Excel Workbook | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | 2009 - 2010 | 2010 - 2011 | 2009 - 2010 | 2010 - 2011 | |||
| 2 | 2008 - 2009 | 2009 - 2010 | 2008 - 2009 | ||||
| 3 | 2007 - 2008 | 2008 - 2009 | 2007 - 2008 | ||||
| 4 | 2006 - 2007 | 2007 - 2008 | 2006 - 2007 | ||||
| 5 | 2005 - 2006 | 2006 - 2007 | 2005 - 2006 | ||||
| 6 | |||||||
Sheet1 | |||||||
