Conditional formatting on an entire row
Solved/Closed
Related:
- Conditional formatting on an entire row
- Saints row 2 cheats - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 1, 2016 at 12:03 PM
Mar 1, 2016 at 12:03 PM
Hi AKA,
Try this:
Best regards,
Trowa
Try this:
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 3, 2016 at 11:24 AM
Mar 3, 2016 at 11:24 AM
Hi AKA,
Thought you only wanted it for row 12.
Change the last part into the row range you want to apply the conditional formatting. Also make sure that the first part refers to the row you currently selected.
So select row 12, add new rule, formula: =12:12<0, select color, change applied range to =$1:$1048576.
Now whenever a value in column A is below, the corresponding row will turn red.
Best regards,
Trowa
Thought you only wanted it for row 12.
Change the last part into the row range you want to apply the conditional formatting. Also make sure that the first part refers to the row you currently selected.
So select row 12, add new rule, formula: =12:12<0, select color, change applied range to =$1:$1048576.
Now whenever a value in column A is below, the corresponding row will turn red.
Best regards,
Trowa
Mar 2, 2016 at 11:00 AM
I am highlighting the whole row then putting one formula into conditional formatting. Any other thoughts?