| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Chg row color if certain criteria is met
How do I make my worksheet chg the row color to a specific color if a cell
equals 100%, but if the cell is between 1 - 99% chg the row color to a different color. -- Thx for your help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Chg row color if certain criteria is met
check out conditional formatting in help
Format-conditional format-formula is =cell=100% "Suddz62" wrote: How do I make my worksheet chg the row color to a specific color if a cell equals 100%, but if the cell is between 1 - 99% chg the row color to a different color. -- Thx for your help! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Chg row color if certain criteria is met
Ok, that worked out good, but I have a couple of cell that weren't
highlighted because the have both letters and numbers in them. Any suggestion on how to get these cells included also in the row color change? -- Thx for your help! "bj" wrote: check out conditional formatting in help Format-conditional format-formula is =cell=100% "Suddz62" wrote: How do I make my worksheet chg the row color to a specific color if a cell equals 100%, but if the cell is between 1 - 99% chg the row color to a different color. -- Thx for your help! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Chg row color if certain criteria is met
if you want the whole row to change, make sure you use the absolute cell
reference for the specific cell which you want to determine the color do you want each cell in the row to change individually. "Suddz62" wrote: Ok, that worked out good, but I have a couple of cell that weren't highlighted because the have both letters and numbers in them. Any suggestion on how to get these cells included also in the row color change? -- Thx for your help! "bj" wrote: check out conditional formatting in help Format-conditional format-formula is =cell=100% "Suddz62" wrote: How do I make my worksheet chg the row color to a specific color if a cell equals 100%, but if the cell is between 1 - 99% chg the row color to a different color. -- Thx for your help! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Chg row color if certain criteria is met
Ok, that worked out good, but I have a couple of cell that weren't
highlighted because the have both letters and numbers in them and this was the problem I was running into before and have not been able to figure out how to fix. Any suggestion on how to get these cells included also in the row color change? -- Thx for your help! "bj" wrote: check out conditional formatting in help Format-conditional format-formula is =cell=100% "Suddz62" wrote: How do I make my worksheet chg the row color to a specific color if a cell equals 100%, but if the cell is between 1 - 99% chg the row color to a different color. -- Thx for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using cell color as criteria | Excel Discussion (Misc queries) | |||
| sumif, criteria, fill color | Excel Discussion (Misc queries) | |||
| Can I color a cell if a certain criteria is met? | Excel Discussion (Misc queries) | |||
| Can criteria in countif statement be a color? | Excel Worksheet Functions | |||
| color cells when criteria is met | Excel Discussion (Misc queries) | |||
Hybrid Mode
