Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ooo-users@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of elderdanlewis@gmail.com
 designates 209.85.213.175 as permitted sender)
Message-ID: <4FC403BA.1080702@gmail.com>
Date: Mon, 28 May 2012 19:01:14 -0400
From: Dan Lewis <elderdanlewis@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:12.0) Gecko/20120429 Firefox/12.0 SeaMonkey/2.9.1
MIME-Version: 1.0
To: ooo-users@incubator.apache.org
CC: Tony <abletony84@gmail.com>
Subject: Re: [Calc] Feature request: Find & Replace colors
References: 
 <CADnJ0kGsdLmY8HdkMxU7UJwPwDQ1ifMFs=iaQCMMQ5SZRDjxmA@mail.gmail.com>
In-Reply-To: 
 <CADnJ0kGsdLmY8HdkMxU7UJwPwDQ1ifMFs=iaQCMMQ5SZRDjxmA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Tony wrote:
> Hey!
>
> I color-code my cells to assist me in entering data, creating or changing
> formulae, or deleting data, formulae and links:
>
>     - Enter data and information in Green shaded cells only
>     - Blue shaded cells calculate results within a spreadsheet
>     - Data in Yellow shaded cells is transferred to other worksheets
>     - Purple shaded cells bring in data from other spreadsheets
>
> But now I want to replace those colors with different shades, and cannot
> find a function to do so.
>
> Could OpenOffice.org Calc perhaps incorporate a Find&  Replace function
> similar to that of, say, the Adobe apps?
>
> http://i.imgur.com/Xu9JG.png
>
> Thanks for listening.
>
> Tony
>
      Had you used cell styles to define these colors and applied these 
styles to the cells of your spreadsheet, changing any of the colors 
would be a snap. All you would have to do is to change the color in the 
appropriate style.
      Furthermore, if you need a cell for a given purpose, you would 
only have to click the cell and double click the proper style.

--Dan

---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org