Change Row Color With Conditional Formatting Closed

Question

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

finance · Answer

looking for solution

rizvisa1 · Answer

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

Change Row Color With Conditional Formatting

2 responses

Similar discussions

Subscribe To Our Newsletter!