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 ,
Steve COR 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 ,
Steve COR 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 ,
Steve COR 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 wrote in message
...
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 ,
Steve COR 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