Data Validation with colour

I

ianripping

Is it possible to have Data validation for a list of values but ad
colour to a selection of them?

At the moment they change back to the default colour?

May be an IF Command

Like IF = 6 THEN RE
 
P

Paul

ianripping > said:
Is it possible to have Data validation for a list of values but add
colour to a selection of them?

At the moment they change back to the default colour?

May be an IF Command

Like IF = 6 THEN RED
Click to expand...

Changing colour dependent on data is called "Conditional formatting" and is
to be found on the Format menu. It is independent of Data validation.
 
B

Bob Phillips

Ian,

I think you would have to add the same condition to CF that you have in the
Data Validation.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I

ianripping

OK this workds for one single colour but not multiple colours.

Any clues for multi colours
 
B

Bob Phillips

It can work for 3 colours, you just add extra conditions.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I

ianripping

So do I put the CF on the source data?

I've tried this and it still wont work. Could you create an example and
upload it?
 
B

Bob Phillips

Sorry I use a NG reader and attachments are frowned upon.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top