Have currently got the following formula in conditonal formatting:

Formula Is =IF($B6="Cert Received",1,0)

This allows me to copy and paste from a database, and as soon as the phrase
"Cert Received" appears in the designated cell, it changes the colour of 8
cells in the row to green.

What i'm after is the function to add another keyword into that formula, for
example having "Cert Received" as well as "Received Good Certificate",
"Received Acceptable Certificate" etc etc.

Is there a function whether it be comma or the "or" command or something
similar to allow me to add another text keyword for the conditional
formatting to recognise?

From the 'conditional formatting' window click Add and add the next condition.

If this post helps click Yes
---------------
Jacob Skaria


"Ricardo" wrote:

Have currently got the following formula in conditonal formatting:

Formula Is =IF($B6="Cert Received",1,0)

This allows me to copy and paste from a database, and as soon as the phrase
"Cert Received" appears in the designated cell, it changes the colour of 8
cells in the row to green.

What i'm after is the function to add another keyword into that formula, for
example having "Cert Received" as well as "Received Good Certificate",
"Received Acceptable Certificate" etc etc.

Is there a function whether it be comma or the "or" command or something
similar to allow me to add another text keyword for the conditional
formatting to recognise?

Sorry, that's not the answer. I'm trying to add more keywords into 1
condition. I already have 3 conditions set up, all to reflect a different
type of status. E.g. "Received Certificate" "Not received" "failed"

What i'm trying to do is to broaden the field of each one by adding certain
keywords into each. E.g

"received certificate", "received good certificate" and "good certificate"
would all generate a green response by the conditional formatting.

I just need to know the function is to add another word into the formula.

for example something like

Formula Is =IF($B6="Cert Received" or "Received Good Cert",1,0) <- something
like that. I know the OR command doesn't work how i've put it, but I require
something that allows it to look at multiple different entries and give the
same result. E.g. Green.

"Ricardo" wrote:

Have currently got the following formula in conditonal formatting:

Formula Is =IF($B6="Cert Received",1,0)

This allows me to copy and paste from a database, and as soon as the phrase
"Cert Received" appears in the designated cell, it changes the colour of 8
cells in the row to green.

What i'm after is the function to add another keyword into that formula, for
example having "Cert Received" as well as "Received Good Certificate",
"Received Acceptable Certificate" etc etc.

Is there a function whether it be comma or the "or" command or something
similar to allow me to add another text keyword for the conditional
formatting to recognise?

=IF(OR($B6="Received Good Certificate",$B6="Cert Received"),1,0)

"Ricardo" wrote:

Have currently got the following formula in conditonal formatting:

Formula Is =IF($B6="Cert Received",1,0)

This allows me to copy and paste from a database, and as soon as the phrase
"Cert Received" appears in the designated cell, it changes the colour of 8
cells in the row to green.

What i'm after is the function to add another keyword into that formula, for
example having "Cert Received" as well as "Received Good Certificate",
"Received Acceptable Certificate" etc etc.

Is there a function whether it be comma or the "or" command or something
similar to allow me to add another text keyword for the conditional
formatting to recognise?