I use 2.0.1 and I was able to apply Conditional formatting to non-contiguous cells.
Perhaps someone else can comment on this. Dave On 1/9/06, Dennis Marks <[EMAIL PROTECTED]> wrote: > > I am not able to select "conditional formatting" (it is dimmed out) when > the > multiple cells are selected. By the way the cells are disconnected. They > do > not touch each other. They are selected with cntl click. > > "David Chapman" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > Select the 81 cells. > > One of them is the active cell. It has the square around it. Let's say C6. > > In the conditional formatting dialog - select Function is ... > > ISNUMBER(FIND("S";C6))=TRUE > > Dave > > On 1/8/06, Dennis Marks <[EMAIL PROTECTED]> wrote: > > > > I would like to have conditional formats for 81 different calc cells. > When > > the cell above it contains an "S" then the cell will be red. I have set > up > > a > > format and the condition is very easy to set up. The problem is that the > > same thing has to be done with 81 cells. Is there a quick way to do > this? > > > > -- > > Dennis Marks > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > -- > My OpenOffice Calc Website > http://www.openofficetips.com > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
