Somewhat Conditional Formatting, right?

[waterballoon]

Is there a way to make cells turn a certain color if a completely different cell is a certain value?

I tried with conditional formatting but having no luck...

Thanks in advance!

 

[MrVillareal]

Hi,

Can you provide data that you used?

 

[waterballoon]

What I'm trying to do:

if cell A2 says "change" I want cells B2:D2 to highlight in yellow so editors know to fill those cells in with more data

 

[pgc01]

Hi

Here'a an example:

- Select A1
- in the conditional formatting use the formula:
=$D$1=1
- set some colour to paint the cell in case the condition is met

Now try it. When D1 is equal to 1 you'll see A1 changing colour.

 

[GlennUK]

What I'm trying to do:

if cell A2 says "change" I want cells B2:D2 to highlight in yellow so editors know to fill those cells in with more data

Select cell B2:D2, and do Conditional Formatting, using Formula Is:
=$A2="change"
and then choose your required format, maybe Fill, yellow.

 

[waterballoon]

Worked! Had to change it up a bit but is exactly what I was looking for!

Thanks again!

Brilliant!

 

[waterballoon]

How do I go about applying it to multiple cells? but by going row by row?

ie: a1 with b1:d1, a2 with b2:d2 and so on...

 

[GlennUK]

Select B1:D999 ( or whatever ) and use a formula relative to the active cell, ( activecell should be B1 ), so condition formula would be:

=$A1="change"

 

[waterballoon]

Thank you--figured it out!