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
|