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]
