| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I create an AutoFormat row color change for a value in a c
I use Microsoft Excel to keep track of our inventory. I have a formula on my
"Quantity to Order" column that allows the program to automatically change the cell color to red when the value gets below zero. Is there a way that I can use this same numerical limit to change the color of the entire row? If so, can you give me the formula, or something similar? Thanks, Shane |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I create an AutoFormat row color change for a value in a c
Hi
Select the row and use this in CF: =$A2<0 presuming A2 is your cell! Andy. "Shane Rary" <Shane wrote in message ... I use Microsoft Excel to keep track of our inventory. I have a formula on my "Quantity to Order" column that allows the program to automatically change the cell color to red when the value gets below zero. Is there a way that I can use this same numerical limit to change the color of the entire row? If so, can you give me the formula, or something similar? Thanks, Shane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create database in excel? | New Users to Excel | |||
| quickly create extra copies of a worksheet template in a workbook | Excel Worksheet Functions | |||
| how to apply template in excel ? or can I create a autoformat in e | Excel Worksheet Functions | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
Hybrid Mode
