Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Shading
I am tracking RMA's. I have a spreadsheet wher I enter customers
name,product being returned, opened, closed, date, etc. When I mark an "x" in the cell marked open I want the entire row to shade in one color. When I mark "x" in the cell marked closed I want the row to change color. How do I accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Shading
Have a look at Conditional Formatting in Help,
Regards, Alan. "kthornton" wrote in message ... I am tracking RMA's. I have a spreadsheet wher I enter customers name,product being returned, opened, closed, date, etc. When I mark an "x" in the cell marked open I want the entire row to shade in one color. When I mark "x" in the cell marked closed I want the row to change color. How do I accomplish this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Shading
look at formatconditional formatting
-- Don Guillett SalesAid Software "kthornton" wrote in message ... I am tracking RMA's. I have a spreadsheet wher I enter customers name,product being returned, opened, closed, date, etc. When I mark an "x" in the cell marked open I want the entire row to shade in one color. When I mark "x" in the cell marked closed I want the row to change color. How do I accomplish this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Row Shading
conditional formatting. select the rows you're interested in. for this option i'm going to do it on row 1 the active cell is in box A1 format-conditional formatting Change the first dropdown to be a formula =$a1="X" then choose format and choose a pattern add a new rule make it a formula once more =$B1="X" then choose format and choose a pattern again press ok copy the whole row. highlight the rows you want to apply this formatting to and choose "paste special-formats" This assumes that the flags for open and closed appear in cells A1 and B1 you can do this conditional formatting for the entire region at once but you hvae to keep track of where your active cell is. If you're unfamiliar with conditional formatting it's often easiest to get it working for one row then copy that formatting to the whole range -- MDubbelboer ------------------------------------------------------------------------ MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330 View this thread: http://www.excelforum.com/showthread...hreadid=562659 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
sort columns, but not shading | New Users to Excel | |||
how can I use shading as criteria in a formula? | Excel Worksheet Functions | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) |