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+h...@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