| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data - change cell color
I have been successful in getting external data and now would like to
'fancy-up' my spreadsheet. I am new to excel but not programming and would like to know how to change the color of a cell based on data returned. A simple example would be a column that contains a number. If the number is between 1 and 5, I want the cell in that column to be green. If it is between 6 and 8, it should be yellow. 9-10 it should be red. How do I do this for external data?? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data - change cell color
Once the data is in the cell it is no longer external so the best method
would be to add conditional formatting to the column that has the numbers. Have a look at the help files on this, it should point you in the right direction. Nick "MSSQLServerDeveloper" wrote in message ... I have been successful in getting external data and now would like to 'fancy-up' my spreadsheet. I am new to excel but not programming and would like to know how to change the color of a cell based on data returned. A simple example would be a column that contains a number. If the number is between 1 and 5, I want the cell in that column to be green. If it is between 6 and 8, it should be yellow. 9-10 it should be red. How do I do this for external data?? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data - change cell color
Thanks Nick
"Nick" wrote: Once the data is in the cell it is no longer external so the best method would be to add conditional formatting to the column that has the numbers. Have a look at the help files on this, it should point you in the right direction. Nick "MSSQLServerDeveloper" wrote in message ... I have been successful in getting external data and now would like to 'fancy-up' my spreadsheet. I am new to excel but not programming and would like to know how to change the color of a cell based on data returned. A simple example would be a column that contains a number. If the number is between 1 and 5, I want the cell in that column to be green. If it is between 6 and 8, it should be yellow. 9-10 it should be red. How do I do this for external data?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color fill when data in cell changes | Excel Discussion (Misc queries) | |||
| Linking data between sheets to change color of cell? | Excel Discussion (Misc queries) | |||
| Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
| How do I change fill color in excel based on data in the cell | Excel Worksheet Functions | |||
Hybrid Mode
