General Question

2davidc8's avatar

In Excel, how do I conditionally change a row's fill color?

Asked by 2davidc8 (10189points) June 6th, 2018

This is what I’d like to do:
Say I have a Column B which contains certain codes. In some rows, the code might be ‘MDVA’, in others, ‘L’, ‘R’, or ‘Cx’. For any row in which the value is ‘L’, for example, I want to make the background color light blue for the entire row, not just that one cell containing ‘L’. For any row in which the value is ‘MDVA’, I want to make the background color light yellow.
How do I do this? Is there a way to do this without getting into VB? Functions and formulas are OK.

Observing members: 0 Composing members: 0

4 Answers

ARE_you_kidding_me's avatar

you have to “make new a rule” under “conditional formatting”

Response moderated (Unhelpful)
2davidc8's avatar

@ARE_you_kidding_me Yes, I basically know how to make a new rule, but what is the command to turn an entire row a certain color?

ARE_you_kidding_me's avatar

I think you have to use the option under rules that says “use a formula to determine which cells to format” I think you can use =LEFT and =RIGHT

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther