I still have 2.0.0. I don't have the time to download a new version yet. Slooow dialup. BTW: I tried it with 3 multiple contiguous areas and it works. Maybe 81 is too many areas.
"David Chapman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
