color coding

A

Abhi

How do i use conditional formatting and data validation in conjunction, and
apply the color coding to a range of cells
 
J

Joel

You can copy the conditional formating by copying the cell with the CF select
the destination cell(s) and then use PasteSpecial with the option format.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

color coding 2
Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA - Problem with Closing Print Preview 0
Counting the number of rows based on the color 2
How do I change the color of cells with a macro 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Conditional Formating with IF and AND formula 2

Top