| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
