Conditional Formatting on cell with a formula

[Guest]

Hi! I'm having trouble with conditional formatting on cells in one sheet that
have formulas referring to another sheet. I have one sheet called
"Worksheet". The user enters data in that sheet that is then transferred to
another sheet called "Print Sheet". Say Print Sheet cell A1 has the formula
"=IF(Worksheet!A6>0,Worksheet!A6,"")" The conditional formatting I want on
Print Sheet is if Print Sheet cell A1 has the value from Worksheet A6 showing
(in otherwords Worksheet A6 was >0) then Print Sheet cell A1 is to be colored
gray. If the IF statement proved false and Print Sheet A1 shows blank or "",
then Print Sheet A1 is to be conditionally formatted nothing. I tried the
conditional formatting "cell value is" <0 and it still conditionally
formatted the cell fill in gray because Print Sheet cell A1 does have a cell
value... the IF statement formula... see what I mean? I also tried reference
to sheet Worksheet cell A6, but Conditional Formatting doesn't like to look
to other sheets. I even tried using this formuly [Staff
Schedule.xls]Worksheet!$A$6 to help conditonal formatting deal with reference
to another worksheet and it didn't like it. Can anyone help me with this?
Thanks!

 

[Guest]

Try using conditional formatting with "formula is" option using formula

=A1<>""

 

[Gord Dibben]

Select A1 then Format>CF>Formula is: =A1<>""

Format>Pattern.


Gord Dibben MS Excel MVP

 

[Guest]

Oh, I just got it.... =NOT($A$11=("")). I also see 2 replys that look less
complicated. Thanks daddylonglegs and Gord Dibben! I always do things the
hard way. Thanks so much for your time!

 

[Guest]

I need some similar help - can you possibly help me?

In a cell in a wksheet, it has a formula that pulls the value/words from
another worksheet cell. If the cell it's referencing is blank, Excel gives me
a "O" in the destination cell.

How do I make it give a blank if the referenced cell is empty?

Try using conditional formatting with "formula is" option using formula

=A1<>""

Hi! I'm having trouble with conditional formatting on cells in one sheet that
have formulas referring to another sheet. I have one sheet called
"Worksheet". The user enters data in that sheet that is then transferred to
another sheet called "Print Sheet". Say Print Sheet cell A1 has the formula
"=IF(Worksheet!A6>0,Worksheet!A6,"")" The conditional formatting I want on
Print Sheet is if Print Sheet cell A1 has the value from Worksheet A6 showing
(in otherwords Worksheet A6 was >0) then Print Sheet cell A1 is to be colored
gray. If the IF statement proved false and Print Sheet A1 shows blank or "",
then Print Sheet A1 is to be conditionally formatted nothing. I tried the
conditional formatting "cell value is" <0 and it still conditionally
formatted the cell fill in gray because Print Sheet cell A1 does have a cell
value... the IF statement formula... see what I mean? I also tried reference
to sheet Worksheet cell A6, but Conditional Formatting doesn't like to look
to other sheets. I even tried using this formuly [Staff
Schedule.xls]Worksheet!$A$6 to help conditonal formatting deal with reference
to another worksheet and it didn't like it. Can anyone help me with this?
Thanks!

 

[Guest]

Instead of using this kind of link formula: =Sheet1!A1
you could try something like this:
=IF(Sheet1!A1="","",Sheet1!A1)