conditional formatting update issue

[Colin Hayes]

Hi

In conditional formatting I use this formula :

=COUNTIF($F17:$I17,0)=2

formatted to apply the colour white to the font to effectively blank out
all cells between $F17:$I17 if any are empty.

If any of the cells in the range are empty , then all content is
coloured white and 'disappears' on the screen. If I make an entry then
the content of the cells appears black and becomes visible.

Curiously though if I remove the entry and make the cell blank again ,
they don't follow the formatting and become white again. They stay black
, even though the range now has the empty cell which should trigger the
condition formatting.

Can anyone suggest a formula which would correct this?


Grateful for any help.



Best Wishes

 

[Claus Busch]

Hi Colin,

Am Sat, 15 Sep 2012 15:54:55 +0100 schrieb Colin Hayes:

=COUNTIF($F17:$I17,0)=2

formatted to apply the colour white to the font to effectively blank out
all cells between $F17:$I17 if any are empty.

If any of the cells in the range are empty , then all content is
coloured white and 'disappears' on the screen. If I make an entry then
the content of the cells appears black and becomes visible.

Curiously though if I remove the entry and make the cell blank again ,
they don't follow the formatting and become white again. They stay black
, even though the range now has the empty cell which should trigger the
condition formatting.

if you have numbers in F17:I17 then try:
=COUNT($F17:$I17)<=2
With text try:
=COUNTA($F17:$I17)<=2



Regards
Claus Busch

 

[GS]

If you're looking to hide zeros resulting from formulas, just use 'Cell
value is equal to' and enter zero as your criteria.

Alternatively, you could wrap your formula in an IF construct so it
returns an empty string when the result equals zero.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Colin Hayes]

if you have numbers in F17:I17 then try:

=COUNT($F17:$I17)<=2
With text try:
=COUNTA($F17:$I17)<=2



Regards
Claus Busch

Hi Claus

OK this works fine now with empty cells - thanks.

It's the number one I needed in my circumstance.

^_^

Best Wishes


Colin

 

[Colin Hayes]

If you're looking to hide zeros resulting from formulas, just use 'Cell
value is equal to' and enter zero as your criteria.

Alternatively, you could wrap your formula in an IF construct so it
returns an empty string when the result equals zero.

Hi Garry

Thanks for your feedback. I just needed it to apply to entirely empty
cells , so I've got to working now. A lot of formula and format pasting
, but it's working!



Best Wishes


Colin

 

[support]

Hi



In conditional formatting I use this formula :



=COUNTIF($F17:$I17,0)=2



formatted to apply the colour white to the font to effectively blank out

all cells between $F17:$I17 if any are empty.



If any of the cells in the range are empty , then all content is

coloured white and 'disappears' on the screen. If I make an entry then

the content of the cells appears black and becomes visible.



Curiously though if I remove the entry and make the cell blank again ,

they don't follow the formatting and become white again. They stay black

, even though the range now has the empty cell which should trigger the

condition formatting.



Can anyone suggest a formula which would correct this?





Grateful for any help.







Best Wishes

Hi,
There is complete Video Tutorial Series on Conditional formatting that ihave created hope that would help you. http://www.youtube.com/playlist?list=PLA6FD047BBA06B5A8