98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting by row
Conditional Formatting by row
Resolved · Medium Priority · Version 2010
Fri 7 Apr 2017, 12:28Delegate Alisdair said...
Alisdair has attended:
Excel Intermediate course
Conditional Formatting by row
Hi,
I am trying to format my tables so that if one of the cells in the row shows a certain value the entire row will go a certain colour. The three possible values are 0, 1 and 2 and I want the colours to be green orange and yellow.
I have managed to do this for a single row by highlighting the row and entering a rule with the formula =$F$5=2 and formatting the colour I would like. I cant seem to be able to do this for the table however, and when I try to copy it still works from whatever the value in the first cell is.
Can you please help?
Fri 7 Apr 2017, 16:16Trainer Andrew said...
RE: Conditional Formatting by row
Hi Alisdair
Thank you for your question - that formula will almost do the trick. The only thing that needs removing is the $ before the number 5.
By removing that your format can be applied to the other rows using format painter.
Let me know if that solves the problem.
Thanks,
Andrew
Fri 14 Apr 2017: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Sorting List SubtotalsIf you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows. |
