Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for Rows based on one cell's outcome
I am creating an inventory list for our company. I have 5 columns:
Part//On hand//Inv. Minimum//Restock Y/N//Restock Amount I would like to use Conditional Formatting to highlight the Part and/or the entire row when there is a restock amount greater than 0. I have tried different combonations in Conditional Formatting but nothing is working. Can someone please give me directions on how to do this???? I would greatly appreciate it! THANKS! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for Rows based on one cell's outcome
Hi
Highlight the complete block of data from row 2 downward. FormatConditional Formatting.Formula is=$D20 Formatyour choice -- Regards Roger Govier "adnamadawn" wrote in message ... I am creating an inventory list for our company. I have 5 columns: Part//On hand//Inv. Minimum//Restock Y/N//Restock Amount I would like to use Conditional Formatting to highlight the Part and/or the entire row when there is a restock amount greater than 0. I have tried different combonations in Conditional Formatting but nothing is working. Can someone please give me directions on how to do this???? I would greatly appreciate it! THANKS! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for Rows based on one cell's outcome
Well. . . I tried your instructions and nothing happened. Is there something
else I could do? Or do you have any ideas on why its not working? Thanks! "Roger Govier" wrote: Hi Highlight the complete block of data from row 2 downward. FormatConditional Formatting.Formula is=$D20 Formatyour choice -- Regards Roger Govier "adnamadawn" wrote in message ... I am creating an inventory list for our company. I have 5 columns: Part//On hand//Inv. Minimum//Restock Y/N//Restock Amount I would like to use Conditional Formatting to highlight the Part and/or the entire row when there is a restock amount greater than 0. I have tried different combonations in Conditional Formatting but nothing is working. Can someone please give me directions on how to do this???? I would greatly appreciate it! THANKS! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting for Rows based on one cell's outcome
Hi
It works fine for me Perhaps you mis-interpreted the I used to break up the steps and included the one after Format The format condition is just =$D20 -- Regards Roger Govier "adnamadawn" wrote in message ... Well. . . I tried your instructions and nothing happened. Is there something else I could do? Or do you have any ideas on why its not working? Thanks! "Roger Govier" wrote: Hi Highlight the complete block of data from row 2 downward. FormatConditional Formatting.Formula is=$D20 Formatyour choice -- Regards Roger Govier "adnamadawn" wrote in message ... I am creating an inventory list for our company. I have 5 columns: Part//On hand//Inv. Minimum//Restock Y/N//Restock Amount I would like to use Conditional Formatting to highlight the Part and/or the entire row when there is a restock amount greater than 0. I have tried different combonations in Conditional Formatting but nothing is working. Can someone please give me directions on how to do this???? I would greatly appreciate it! THANKS! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on other cells | Excel Discussion (Misc queries) | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
CONDITIONAL FORMATTING BASED ON RESULTS IN A CELL | Excel Worksheet Functions | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |