Change Row Color With Conditional Formatting

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

looking for solution