Conditional Formula-Formulas

S

Steve COR

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
 
J

JE McGimpsey

One way:

Use the dropdowns and inputbox to enter something like:

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

Fiona K

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 :)
 
Top