Horus

Junior Member

Location: Lund, Sweden.

Posts: 5

Quote:

Originally Posted by Claus Busch

Hi Frederik,

Is this a known limitation of the feature? I have not
found any information as to why this should not work.

for the data bar you can only select a color but you could not refer it
to a value

I understand that, which is why I tried with the stop-if-true rules between three different data bar formattings. I don't see why that should not work, but for now I will resort to VBA as you proposed.

Thank you,
Fredrik

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting a tab color	Rhino V[_2_]	Excel Programming	3	August 9th 09 11:29 PM
If formula control conditional formatting	Very Basic User	Excel Discussion (Misc queries)	2	July 8th 09 06:01 PM
conditional formatting for tab color	Rosanne	Excel Worksheet Functions	2	October 29th 08 11:22 PM
Conditional color formatting entries have wild color.	John Geyer	Excel Discussion (Misc queries)	0	February 24th 06 06:11 PM
See conditional formatting Color value in vba	Gunnar Sandström	Excel Programming	1	November 17th 05 01:27 PM

All times are GMT +1. The time now is 08:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us