[libreoffice-users] Conditional Formatting columns

Hi
Conditional Formatting columns
Sheet name DH April
I have a area/grid of 8 columns E10 to L40, in cell W7 I have a number (1 to
8)
I want to starting from the first column (E10) conditionally colour a number
of the columns depending upon the number in W7
This is the Conditional Formatting formula I'm using
COLUMN()-COLUMN($'DH April'.$E$10)>=$'DH April'.$W$7
Its not doing as I expected, its colouring the columns/area not from the
first column but from the first column plus whatever the number is
Any ideas on how to get this working

-----
IGraham

W764  LibreOffice 3.5.2.2 
--
View this message in context: 
http://nabble.documentfoundation.org/Conditional-Formatting-columns-tp3896993p3896993.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted