| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing just one column
Format / Conditional Formatting should do it. Do you want the whole column to turn red if a
certain number anywhere is greater than .5, or do you want each cell in that column to turn red if the number in it is greater than .5 -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- "Dan" wrote in message ... I have a spreadsheet that I would like just one column to change color to red if the number in the column is greater than .5 otherwise I don't want anything to happen. I assume that this would be a VB coding issue. Thx Dan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing just one column
Each cell should change if the condition is meet.
Preferably just the number and not the cell. Dan -----Original Message----- Format / Conditional Formatting should do it. Do you want the whole column to turn red if a certain number anywhere is greater than .5, or do you want each cell in that column to turn red if the number in it is greater than .5 -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP --------------------------------------------------------- ------------------- Attitude - A little thing that makes a BIG difference --------------------------------------------------------- ------------------- "Dan" wrote in message ... I have a spreadsheet that I would like just one column to change color to red if the number in the column is greater than .5 otherwise I don't want anything to happen. I assume that this would be a VB coding issue. Thx Dan . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing just one column
Select the column in question, do Format / Conditional formatting / Choose 'Cell Value is'
'Greater Than' 0.5 Then click on the format button, and either change the font if you want the text to turn a different colour, or hit the patterns tab if you want to change the cell to a different colour when the condition is met. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ---------------------------------------------------------------------------- wrote in message ... Each cell should change if the condition is meet. Preferably just the number and not the cell. Dan -----Original Message----- Format / Conditional Formatting should do it. Do you want the whole column to turn red if a certain number anywhere is greater than .5, or do you want each cell in that column to turn red if the number in it is greater than .5 -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP --------------------------------------------------------- ------------------- Attitude - A little thing that makes a BIG difference --------------------------------------------------------- ------------------- "Dan" wrote in message ... I have a spreadsheet that I would like just one column to change color to red if the number in the column is greater than .5 otherwise I don't want anything to happen. I assume that this would be a VB coding issue. Thx Dan . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
| MS Excel - changing reference column value based on another column | Excel Discussion (Misc queries) | |||
| Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
| Column changing | Excel Worksheet Functions | |||
| Changing a column name | Excel Discussion (Misc queries) | |||
Linear Mode
