Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

The cell I am trying to format has a formula in it that pulls the result from another sheet in the workbook. If the result returns as "No", or "Started", I want them to highlight in Red Bold.

I've tried setting the cell value with one condition for No, and a second for Started - but not working. Actually, if I were typing the words No or Started in the cell, it WOULD work - but it seems the problem is the fact that the value is coming from another page.

??? I've read another mail that talked about "naming" the cell in the originating page, and then setting the conditional formatting. Tried that - but unsuccessful, and not sure I was doing it right.

Argh. So, if the above is the solution - can you take it slow?

Thank you!
Carol
 
Hi Carrol,

Set the CF like this:

Formula Is: =OR(A1="NO",A1="STARTED")

Adjust the cell ref as needed.

Biff
-----Original Message-----
Hello.

The cell I am trying to format has a formula in it that
Click to expand...
pulls the result from another sheet in the workbook. If
the result returns as "No", or "Started", I want them to
highlight in Red Bold.
I've tried setting the cell value with one condition for
Click to expand...
No, and a second for Started - but not working.
Actually, if I were typing the words No or Started in the
cell, it WOULD work - but it seems the problem is the fact
that the value is coming from another page.
??? I've read another mail that talked about "naming"
Click to expand...
the cell in the originating page, and then setting the
conditional formatting. Tried that - but unsuccessful,
and not sure I was doing it right.
 
Hello Biff.

Thanks for the info - but it did not work. Like I said, the words "Started" and "No" are pre-filling from a different page, and excel does not seem to recognize them because of that.

Is there any other solution?
thanks
Carol



----- Biff wrote: -----

Hi Carrol,

Set the CF like this:

Formula Is: =OR(A1="NO",A1="STARTED")

Adjust the cell ref as needed.

Biff
-----Original Message-----
Hello.
Click to expand...
pulls the result from another sheet in the workbook. If
the result returns as "No", or "Started", I want them to
highlight in Red Bold.No, and a second for Started - but not working.
Actually, if I were typing the words No or Started in the
cell, it WOULD work - but it seems the problem is the fact
that the value is coming from another page.the cell in the originating page, and then setting the
conditional formatting. Tried that - but unsuccessful,
and not sure I was doing it right.
 
I've found that some formulas require references to be absolute. Try altering your A1 references to $A$1 and see if this helps.

Louise
 
Thanks Louise.

This didn't work either.

There is currently a formula in the cell I'm trying to apply the conditional formatting to:
=IF(RA!A103="x","Yes"," ")&IF(RA!A104="x","Started"," ")&IF(RA!A105="x","No"," ")

Does this help?
Carol
----- Louise wrote: -----

I've found that some formulas require references to be absolute. Try altering your A1 references to $A$1 and see if this helps.

Louise
 
Why do you concatenate the formula and use spaces.
The reason the conditional formatting won't work is because
you attach a space to the answer if it is not "Yes" (actually 2 spaces if
No is the answer. Rewrite the formula to

=IF(RA!A103="x","Yes",IF(RA!A104="x","Started",IF(RA!A105="x","No","")))

now apply the conditional formatting or change the conditional formatting to

=OR(TRIM(A1)="Started",TRIM(A1)="No")

it is always a bad idea to put a space into a cell, use "" for empty looking
cells


--

Regards,

Peo Sjoblom


Carol said:
Thanks Louise.

This didn't work either.

There is currently a formula in the cell I'm trying to apply the conditional formatting to:
=IF(RA!A103="x","Yes"," ")&IF(RA!A104="x","Started"," ")&IF(RA!A105="x","No"," ")

Does this help?
Carol
----- Louise wrote: -----

I've found that some formulas require references to be absolute. Try
Click to expand...
altering your A1 references to $A$1 and see if this helps.
 
=AND(RA!A103="x",RA!A104="x",RA!A105="x")


--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
Carol said:
Thanks Louise.

This didn't work either.

There is currently a formula in the cell I'm trying to apply the conditional formatting to:
=IF(RA!A103="x","Yes"," ")&IF(RA!A104="x","Started"," ")&IF(RA!A105="x","No"," ")

Does this help?
Carol
----- Louise wrote: -----

I've found that some formulas require references to be absolute. Try
Click to expand...
altering your A1 references to $A$1 and see if this helps.
 
Your formula could be changed to:

=IF(RA!A103="x","Yes",IF(RA!A104="x","Started",IF(RA!A105="x","No","")))

When you set the conditional formatting, refer to the cell that is
receiving the formatting. For example, if the above formula is in cell B5:

1. Select cell B5
2. Choose Format>Conditional Formatting
3. From the first dropdown, choose Formula Is
4. In the Formula box, type a formula that refers to the active cell:
=OR(B5="No",B5="Started")
5. Click the Format button, and choose options that you want
6. Click OK, click OK
 
Back
Top