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
 
S

smartin

Abhi said:
How do i use conditional formatting and data validation in conjunction, and
apply the color coding to a range of cells
Click to expand...

What exactly do you mean by "use ... in conjunction"? If you want CF to
highlight failed validation, you need to use the same criteria in both
places.

If you are wondering how to use CF try Googling "excel conditional
formatting" for lots of ideas, or post back if you have a more specific
question.
 
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
Changing row background from external program 0
Need help modifying code 0
Address Format changed after Migration 0
Match table shading (color) to Visio color/Transparency 1
Tracked changes by multiple people modified to one 0
Fill tringle in a cell with color 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top