I am putting together a conditional formatting criteria under the
"Format-Conditional Formatting" tool. I have the format of text change fonts
and color when a specific text string is entered, but am limited to three
entries/criteria.

My question is can I enter more than one string on one line within the
conditional format entry block?
tx Steve

One way:

Use the dropdowns and inputbox to enter something like:

CF1: Formula is =OR(A1="string1",A1="string2",A1="string3")
Format1: <font>/<color>

In article <25D1C68D-D533-4C67-9034-(E-Mail Removed)>,
Steve COR <(E-Mail Removed)> wrote:

> I am putting together a conditional formatting criteria under the
> "Format-Conditional Formatting" tool. I have the format of text change fonts
> and color when a specific text string is entered, but am limited to three
> entries/criteria.
>
> My question is can I enter more than one string on one line within the
> conditional format entry block?
> tx Steve

Hi

I was not sure how to post - but I have a similar question about using
summing cells which are formatted a certain way. Is it possible to do a
formula that looks to a certain range for a certain format of a number, e.g.
number is 'red' and then goes to another column and if there are numbers that
match this format, i.e. are 'red' it sums these numbers?

I was trying with =SUMIF(x range there, is a number colored 'red' or
conditional format name, look in y range for a number of the same format and
sum)

Does this make sense? I am trying to create an automatic way of summing the
number of hours of each different production stage of multiple projects per
day of the year. Hence, it is difficult to create it based on normal IF
conditions.

I would really appreciate it if you can tell me if this is possible or not
and any other option I might have for automating

"JE McGimpsey" wrote:

> One way:
>
> Use the dropdowns and inputbox to enter something like:
>
> CF1: Formula is =OR(A1="string1",A1="string2",A1="string3")
> Format1: <font>/<color>
>
> In article <25D1C68D-D533-4C67-9034-(E-Mail Removed)>,
> Steve COR <(E-Mail Removed)> wrote:
>
> > I am putting together a conditional formatting criteria under the
> > "Format-Conditional Formatting" tool. I have the format of text change fonts
> > and color when a specific text string is entered, but am limited to three
> > entries/criteria.
> >
> > My question is can I enter more than one string on one line within the
> > conditional format entry block?
> > tx Steve
>

Take a look at Chip Pearson's site:
http://cpearson.com/excel/colors.htm

Fiona K wrote:
>
> Hi
>
> I was not sure how to post - but I have a similar question about using
> summing cells which are formatted a certain way. Is it possible to do a
> formula that looks to a certain range for a certain format of a number, e.g.
> number is 'red' and then goes to another column and if there are numbers that
> match this format, i.e. are 'red' it sums these numbers?
>
> I was trying with =SUMIF(x range there, is a number colored 'red' or
> conditional format name, look in y range for a number of the same format and
> sum)
>
> Does this make sense? I am trying to create an automatic way of summing the
> number of hours of each different production stage of multiple projects per
> day of the year. Hence, it is difficult to create it based on normal IF
> conditions.
>
> I would really appreciate it if you can tell me if this is possible or not
> and any other option I might have for automating
>
> "JE McGimpsey" wrote:
>
> > One way:
> >
> > Use the dropdowns and inputbox to enter something like:
> >
> > CF1: Formula is =OR(A1="string1",A1="string2",A1="string3")
> > Format1: <font>/<color>
> >
> > In article <25D1C68D-D533-4C67-9034-(E-Mail Removed)>,
> > Steve COR <(E-Mail Removed)> wrote:
> >
> > > I am putting together a conditional formatting criteria under the
> > > "Format-Conditional Formatting" tool. I have the format of text change fonts
> > > and color when a specific text string is entered, but am limited to three
> > > entries/criteria.
> > >
> > > My question is can I enter more than one string on one line within the
> > > conditional format entry block?
> > > tx Steve
> >

--

Dave Peterson

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Fiona K" <Fiona (E-Mail Removed)> wrote in message
newsF1968A4-A820-4618-98A7-(E-Mail Removed)...
> Hi
>
> I was not sure how to post - but I have a similar question about using
> summing cells which are formatted a certain way. Is it possible to do a
> formula that looks to a certain range for a certain format of a number,
> e.g.
> number is 'red' and then goes to another column and if there are numbers
> that
> match this format, i.e. are 'red' it sums these numbers?
>
> I was trying with =SUMIF(x range there, is a number colored 'red' or
> conditional format name, look in y range for a number of the same format
> and
> sum)
>
> Does this make sense? I am trying to create an automatic way of summing
> the
> number of hours of each different production stage of multiple projects
> per
> day of the year. Hence, it is difficult to create it based on normal IF
> conditions.
>
> I would really appreciate it if you can tell me if this is possible or not
> and any other option I might have for automating
>
> "JE McGimpsey" wrote:
>
>> One way:
>>
>> Use the dropdowns and inputbox to enter something like:
>>
>> CF1: Formula is =OR(A1="string1",A1="string2",A1="string3")
>> Format1: <font>/<color>
>>
>> In article <25D1C68D-D533-4C67-9034-(E-Mail Removed)>,
>> Steve COR <(E-Mail Removed)> wrote:
>>
>> > I am putting together a conditional formatting criteria under the
>> > "Format-Conditional Formatting" tool. I have the format of text change
>> > fonts
>> > and color when a specific text string is entered, but am limited to
>> > three
>> > entries/criteria.
>> >
>> > My question is can I enter more than one string on one line within the
>> > conditional format entry block?
>> > tx Steve
>>