Is there a formula i can use in a conditional format where an entire horizontal row gets highlighted once the value in the respective cell of a vertical column reaches 0?
In other words, column H returns the respective balances of each row, so when H5 becomes 0, i'd like all of row 5 to turn red.
Many thanks!
Short answer: yes.
Longer answer: provide a sample workbook and I'll walk you through how to do it.
Please take greater care with thread titles in future: they should NOT be generic.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Administrative Note:
Just spotted that this is a duplicate thread, and you are allowed only ONE thread per issue here.
Please see Forum Rule #2 about thread duplication.
I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...lumn-data.html
Thread closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks