How do I set more that 3. I need 6 or 8.
I want to have color of cell change if one of the 6 or 8 words appears in
the cell.
Thanks,
Jerry
How do I set more that 3. I need 6 or 8.
I want to have color of cell change if one of the 6 or 8 words appears in
the cell.
Thanks,
Jerry
limit is 3. You can, however, check for the appearance of the word by some
formula like
=NOT(ISNA(MATCH(A1,F1:F8,0)))
where F1:F8 contains the list of 8 words and A1 is the active cell. If it's
not an error, the word exists, and you can make the cell be whatever color
you want. You just can't have 8 different colors.
Bob Umlas
Excel MVP
"Jerry Kinder" <[email protected]> wrote in message
news:[email protected]...
> How do I set more that 3. I need 6 or 8.
>
> I want to have color of cell change if one of the 6 or 8 words appears in
> the cell.
>
> Thanks,
> Jerry
>
>
>
Use a second cell to evaluate all your conditions
=IF ( AND ( cond1, cond2, cond3, cond4, ....), TRUE)
Then base your conditional format on that cell.
"Jerry Kinder" <[email protected]> wrote in message
news:[email protected]...
> How do I set more that 3. I need 6 or 8.
>
> I want to have color of cell change if one of the 6 or 8 words appears in
> the cell.
>
> Thanks,
> Jerry
>
>
>
Hi,
Thanks I will give this a try. I also found a Macro the does it also, it
will just take some time to figure out how to manipulate it. I do not know
how to write macros so it is trial and error for me.
Thank,
Jerry
"Jezebel" <[email protected]> wrote in message
news:[email protected]...
> Use a second cell to evaluate all your conditions
>
> =IF ( AND ( cond1, cond2, cond3, cond4, ....), TRUE)
>
> Then base your conditional format on that cell.
>
>
>
>
> "Jerry Kinder" <[email protected]> wrote in message
> news:[email protected]...
> > How do I set more that 3. I need 6 or 8.
> >
> > I want to have color of cell change if one of the 6 or 8 words appears
in
> > the cell.
> >
> > Thanks,
> > Jerry
> >
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks