Conditional Format

A

andiam24

Hello,

I would like to set a conditional format to color each unique value a
different color. It will also be applied to multiple occurences of the value.
The problem is that the values are dynamic and may not always be the same
number of occurences, in the same cell, etc. I have used the formula
IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the occurences
but creating a conditional format has proven out of my league! The way the
spreadsheet is designed, the probability of more than 4 IDs being used at any
given time is slim, so the next time IDs are input, they can use the same
four colors because they will replace the previous IDs. I'm just not sure how
to word the conditional format to identify which values are repeating and
which are unique and color appropriately.

Please help!
And thanks!!
*This is a repost from 3/31/10 where an answer was never attained.
 
J

Jarek Kujawa

is this what you're up to?

select any cell in your range and set the following:

1. condition:
=COUNTIF($F$3:F3,F3)=1
and set your formatting for uniques

2. condition:
=COUNTIF($F$3:F3,F3)>1
and set your formatting for repeating values

copy the cell->select other cells->pastespecial->Formats
 
A

andiam24

Thanks for the response; I tried the formatting and it worked to identify
unique versus repeating values. However, I would like for the formatting to
apply to all similar values, distinguishing between the varying unique values
(see below).

QC0094 (green)
QC0095 (blue)
QC0095 (blue)
QC0100 (purple)
QC0100 (purple)
QC0100 (purple)
QC0102 (red)
QC0102 (red)
 

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

Top