Conditional Formatting Question - Different Cell Colors??

O

olimits7

Hello,

I have a spreadsheet that shows the top ten cell phone users for eac
month, and I would like to apply some type of conditional formatting s
it highlights all the duplicate names each with its own color.

For example:

John Smith = Fill Yellow
Jack Johnson = Fill Green

Does someone know a way I could do this?

Thanks,

Olimits
 
B

Bob Phillips

Do you mean identify the top, fill all instances of that yellow, all 2nd
green, etc?

If so, where is the names, and the item that constitutes top users?
 
P

Paul Sheppard

olimits7 said:
Hello,

I have a spreadsheet that shows the top ten cell phone users for eac
month, and I would like to apply some type of conditional formatting s
it highlights all the duplicate names each with its own color.

For example:

John Smith = Fill Yellow
Jack Johnson = Fill Green

Does someone know a way I could do this?

Thanks,

Olimits7
Click to expand...

Hi Olimits7

You can use Conditional Formatting, as follows

Select all the cells where you may want the cells filled, then selec
Format > Conditional Formatting > next to "Cell Value is select "equa
to" then in the next box type the name, then click on the "Format
button, select the "Patterns" tab and choose which ever colour yo
want, repeat for other names

Hope this helps

Pau
 
Top