Conditional Formatting Question - Different Cell Colors??

  • Thread starter Thread starter olimits7
  • Start date Start date
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
 
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?
 
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

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
 

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

Back
Top