| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting Entire Row Based on single Cell Value
How can I have my entire row highlighted using the conditional format
function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Entire Row Based on single Cell Value
Assuming you are trying to highlight row 2 and partial is in Col D, then
select the cells in the row (or entire row) you want to highlight and use FORUMULA IS with =$D2="Partial) You can paste this format on other rows... $D2 in the formula will change to D3, D4 in other rows... "KKD" wrote: How can I have my entire row highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Entire Row Based on single Cell Value
Sorry mistyped the closing quote
Use =$D2="Partial" "Sheeloo" wrote: Assuming you are trying to highlight row 2 and partial is in Col D, then select the cells in the row (or entire row) you want to highlight and use FORUMULA IS with =$D2="Partial) You can paste this format on other rows... $D2 in the formula will change to D3, D4 in other rows... "KKD" wrote: How can I have my entire row highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Entire Row Based on single Cell Value
Where do I type this in?
-- KKD "Sheeloo" wrote: Sorry mistyped the closing quote Use =$D2="Partial" "Sheeloo" wrote: Assuming you are trying to highlight row 2 and partial is in Col D, then select the cells in the row (or entire row) you want to highlight and use FORUMULA IS with =$D2="Partial) You can paste this format on other rows... $D2 in the formula will change to D3, D4 in other rows... "KKD" wrote: How can I have my entire row highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Entire Row Based on single Cell Value
In the FORMULA IS formula under Conditional Formatting...after selecting the
cells to highlight with row2 (or cells in row 2) as the first row in the selection Like you were doing highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. "KKD" wrote: Where do I type this in? -- KKD "Sheeloo" wrote: Sorry mistyped the closing quote Use =$D2="Partial" "Sheeloo" wrote: Assuming you are trying to highlight row 2 and partial is in Col D, then select the cells in the row (or entire row) you want to highlight and use FORUMULA IS with =$D2="Partial) You can paste this format on other rows... $D2 in the formula will change to D3, D4 in other rows... "KKD" wrote: How can I have my entire row highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting Entire Row Based on single Cell Value
Excellent, thank you!
-- KKD "KKD" wrote: Where do I type this in? -- KKD "Sheeloo" wrote: Sorry mistyped the closing quote Use =$D2="Partial" "Sheeloo" wrote: Assuming you are trying to highlight row 2 and partial is in Col D, then select the cells in the row (or entire row) you want to highlight and use FORUMULA IS with =$D2="Partial) You can paste this format on other rows... $D2 in the formula will change to D3, D4 in other rows... "KKD" wrote: How can I have my entire row highlighted using the conditional format function based on the value of only one cell? I can only get the single cell to highlight. My data is simple: PO# Inv# Amt Status ABC 123 50.25 Partial When the status reads "Partial" I want the entire row to be highlighted, not just the cell that reads "Partial" -- KKD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting an entire row based on one cell's value. | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on entire column | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
| conditional formatting across a row, based on value in a single ce | Excel Discussion (Misc queries) | |||
Linear Mode
