Change Row Color With Conditional Formatting
Closed
stocker88
-
Jul 29, 2010 at 11:27 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 07:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 30, 2010 at 07:29 AM
Hello,
Nees some help. I'm trying to change a row color using conditional formatting based on a value in a given cell. Meaning, if in column D if the value is A it turns green, if the value is P it turns yellow, and D it turns red, etc. I know how to do conditional formatting that if I type a certain word/letter in a cell it will turn color, but how do I format the row to match that color based on what value is entered?
Let me tell you that I am computer stupid and am really stuck! Any help would be appreciated!!
Nees some help. I'm trying to change a row color using conditional formatting based on a value in a given cell. Meaning, if in column D if the value is A it turns green, if the value is P it turns yellow, and D it turns red, etc. I know how to do conditional formatting that if I type a certain word/letter in a cell it will turn color, but how do I format the row to match that color based on what value is entered?
Let me tell you that I am computer stupid and am really stuck! Any help would be appreciated!!
Related:
- Change Row Color With Conditional Formatting
- Notepad++ change background color - Guide
- Saints row 2 cheats - Guide
- Change computer name cmd - Guide
- Change lg tv name - Guide
- How to change date format in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
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
