Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour numbers
hi all
i have a sheet that consists of 7 coloums and unlimited rows, i need to colour a group of numbers so that when they appear they turn a certain colour. tried to do it in conditional but this only allows me to use 3. any help would be appreiciated. jkf |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour numbers
See your other post.
Pete On Mar 23, 9:34*pm, "jkf" wrote: hi all i have a sheet that consists of 7 coloums and unlimited rows, i need to colour a group of *numbers so that when they appear they turn a certain colour. tried to do it in conditional but this only allows me to use 3. any help would be appreiciated. jkf |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
colour numbers
If you could provide a bit more information I might have a solution for you if I don't already do.
With conditional formatting, select all the applicable rows / columns and click Conditional Formatting New Rule select 'Format only cells that contain' then do 'equals to' and put whatever value you need colured once appeared. Fairly straight forward, I hope it helped you mate. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
colour cells, same numbers different worksheets | Excel Worksheet Functions | |||
Change the colour of numbers in a cell if the number is negative | Excel Worksheet Functions | |||
Font colour numbers | Excel Discussion (Misc queries) | |||
Adding numbers in cells based on colour | Excel Worksheet Functions | |||
How to add numbers in a column dependant on their colour | Excel Worksheet Functions |