Tnx all, The solution was to reference the cells without the $ sign before them. If I copied that cell and selected the cells I wanted to apply the conditional format to, selected Paste Special and selected Formats and Formula, it worked a treat.
Thanks to whoever thought of the relative/absolute references as well as the Paste Special. Regards Hylton -- ======================================================================== Hylton is a Lions Club member of Lions Club of Fish Hoek (District 410A) http://www.fishhoeklionsclub.org.za being part of the worlds largest NGO ======================================================================== -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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