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
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!!

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
1
looking for solution
0