Excel 2007 Conditional Formating Highlight Rows
I have a spreadsheet that has data in columns A - G. Column H is filled in manually.
When column H is filled in on, say, Row 5, I need conditional formating to highlight that row (column A - H). If there is nothing in column H for a certain row, nothing is highlighted.
When I try to do it with a ISNOTBLANK, either it works for one row or the whole spreadsheet.
Help?
When column H is filled in on, say, Row 5, I need conditional formating to highlight that row (column A - H). If there is nothing in column H for a certain row, nothing is highlighted.
When I try to do it with a ISNOTBLANK, either it works for one row or the whole spreadsheet.
Help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Both ways worked! Perfect!
Don't know why it never worked for me, but I am glad to finally not pull my hair.
Don't know why it never worked for me, but I am glad to finally not pull my hair.
I selected A2:H6, and then implemented this formula based rule:
=NOT(ISBLANK($H6))
Seems to be working for me...
Regards,
Patrick