Change Row Color With Conditional Formatting
Closed
stocker88
-
Jul 29, 2010 at 11:27 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 07:29 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 07:29 AM
Related:
- Change Row Color With Conditional Formatting
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- How to change date format in excel - Guide
- Notepad++ change background color - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
2 replies
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Jul 30, 2010 at 07:29 AM
Jul 30, 2010 at 07:29 AM
If you want to change color of a row instead of a cell, it is same as cell. Only change you need to do is highlight the row on which you want to apply the format and also in the format formula, you need to give absolute address of column
So if you were had a formula like
= A1=5
you need to change it to
=$A1=5
So again.
1. Select the rows
2. Change the formula to have absolute column address
So if you were had a formula like
= A1=5
you need to change it to
=$A1=5
So again.
1. Select the rows
2. Change the formula to have absolute column address