Conditional Formatting

Microsoft Microsoft excel 2007 full vers...
March 8, 2010 at 05:47:15
Specs: Windows XP
Trying to create Conditional Cormatting for the first time. I am able to set the values so that the cells change colors depending on the value that I input. However, I dont want the value, the actual number, to show up. I just want the color to be shown. For instance, if I input the number 10 the cell color should be RED. Instead, the Cell is RED but eh number 10 is in the cell as well. How do I hide the value?

See More: Conditional Formatting

Report •


#1
March 8, 2010 at 06:11:15
Change the Conditional Formatting so that the Font color matches the Fill color.

I don't have 2007, but that's how I would do it (just did) in 2003.


Report •

#2
March 8, 2010 at 07:32:38
Makes sense but that would mean I would have to change it each and every time. Also, the colors arent 2 or 3 solid colors, in 2007 it has the ability to be a gradient between three solid colors depending on where the number I input. Plus, I am too lazy to change it each and everytime, I would prefer for it to be automatic....

Report •

#3
March 8, 2010 at 10:02:22
If you can't choose a fill color that will match/hide the font color, I'm not sure how you would hide the text, other than with VBA.

That said, I'm not sure why you would have to change it "each and every time".

If I conditionally format a cell so that both the font color and fill color change to a matching color when the condition has been met, that would be "automatic". Been there, done that.

Maybe I'm missing something. Why would you need to change it "each and every time"?


Report •

Related Solutions

#4
March 8, 2010 at 14:28:36
Hi,

Have your result in another cell, out of view - say in column AA,

then set the conditional formatting of the cell you want to change color based on the out of view cell which contains the real value.

The cell that changes color therefore has NO text in it, so you will only see the color.

Regards


Report •

#5
March 8, 2010 at 16:01:43
Hi,

My previous suggestion (response #4) may not work if you are using the Excel color scales, as there is no option for changing color based on values in other cells.

As a completely different approach try this:
Format the cells as follows:
Font size=1
Cell Alignment - Horizontal, select 'Right (Indent)' and increase the indent to say 30
The text in the cell should no longer be visible.

Regards


Report •

#6
March 9, 2010 at 01:04:01
Humar,

The work around from Reply 5 worked like a charm!

Thanks so very much.....


Report •

#7
March 9, 2010 at 04:24:10
You're very welcome.

Regards

Humar


Report •


Ask Question