Search : in
By :

Conditional Format - More than 3 colours

Last answer on Jan 15, 2009 9:19:05 am GMT Jaya, on Jan 15, 2009 12:30:16 am GMT 
 Report this message to moderators

Hello,

I want to do a conditional formatting.

It relates to colouring range of cells. There are more than 3 colours so I can't use Excel Conditional Formatting.

For example:

A1 = F06
then colour in B1:D1 is RED.

How can I do that through Macro?

Where can I find the colour codes?

Thank you.

Regards,
Jaya

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Conditional Format More than 3 colours » in :
Unlimited Conditional Formatting Show Unlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
How to create your own Website ShowHow to create your own Website What is HTML? Example 1: HTML Tags HTML Elements Basic HTML Tags to Remember Example 2 HTML Attributes and Values Example 3 Colour Tags Example 4 Text Formatting Example 5 HTML Division Tags Example...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Download AVStoDVD ShowIn most cases, programs offer to convert DVD to other formats more standardized and less bulky. But it is rare to find tools that are the opposite. AVStoDVD is a flexible tool for converting various video formats to DVD format. Advantage The video...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Mini-DIN connector Show4-pin Mini-DIN connector The 4-pin Mini-DIN connector is used for transmitting analog video in S-Video format: More and more graphics cards these days have an S-Video socket built in, so that the computer's output can be viewed on a television...

1

 dellvostro, on Jan 15, 2009 9:19:05 am GMT
  • +1

Hi,

try this link to get more information about the topic you are searching for:

http://en.allexperts.com/...

Reply to dellvostro