View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default add colours to caracters

Hi Sheva,
You can easily accomplish this through CONDITIONAL FORMATTING.
- Highlight the entire sheet (or column that will contain the number that
you are searching for)
- From the menu select FORMAT Conditional Format
- From the box select CELL VALUE IS EQUAL TO
- In the box beside that type in the value you are looking to highlight
- Press the FORMAT button and select the color that you wish to apply to
that number

If you want to look for and change the color of other numbers, then click on
ADD and repeat the above steps.

HTH
Tom

"sheva" wrote:

I would like to add different colours to different numbers in an excel sheet.

So for example "1234" should be green every time when these determined
caracters (numbers) appears on the sheet.
Can I do it? And if yes, can i match more determined caracters with
different coulours.

Thanks!