Is there a way to highlight a whole row when a condition is met in one cell? If so what is the formula that needs to be used and could I apply it through conditional formatting? If you look at my spreadsheet I already used conditional formatting to highlight certain cells according to the number but I need it to highlight the whole row the same color. Any help would be appreciated.
Thank you.
I set the color to column Z can lengthen or decrease
hello
Formattazione.zip
Berna11' solution will high-light the row up to Z (its never a good idea to CF an entire row or column tho, its very recourse-intensive)
an alternative is to just high-light the part of the row you want to change color and use the following dynamic formula
=INDIRECT("column-with-condition-to-test"&ROW())="cell-with-condition-to-test")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks