# Conditional Formatting Based on Other Cell

1. ## Conditional Formatting Based on Other Cell

I currently have conditional formatting set to fill in cells in columns B:C with the red pattern. Once either YES or NO is chosen from the drop-down, that red pattern goes away. What I'm wanting now is to format the corresponding rows in Columns D:P to fill in with that same red pattern IF the corresponding cell to the left (B:C) is marked YES. Essentially- the cells are to fill in with the 'red pattern' when the user needs to fill in a value. Hence, the cells in B:C fill in red until either YES or NO is chosen, and I want the cells in D:P to fill in IF the cell to the left if marked YES, because if it's marked YES that means there is an 'impact' and the associate needs to explain the impact in D:P.

In the example, I would want Row 39 D:P, Row 42 D:P and Row 43 D:P all to have the 'red pattern' in their cells because the column to the left of them was marked 'YES'.

Is there a conditional formatting rule I can use for cells D:P that will format them ONLY if the cell to the left (B:C) is marked YES.

2022-03-30_14-22-24.jpg

2. ## Re: Conditional Formatting Based on Other Cell

That's exactly what conditinal formatting means if formats cells accordign to an indicated condition.
Use the refefence of the YES and or NO cells

3. ## Re: Conditional Formatting Based on Other Cell

You would think, but for some reason I cannot get it to work. This is what I've used:

Cond Form based off formula. Formula is: =\$B\$5=YES . Formula is applied to cells: =\$D\$5:\$P\$19

4. ## Re: Conditional Formatting Based on Other Cell

Attachment 774855

Here is a picture.

5. ## Re: Conditional Formatting Based on Other Cell

NVM- figured it out!

Next question- is there a way to highlight a row of cells UNTIL one of them is filled in with a value?

Example (see screenshot, attached): I want Row 51, Columns B:P formatted with a fill color UNTIL one of the cells in that row has a value in it. In this example, the row would remain filled with a background color UNTIL someone marks an 'X' in one of the cells, then the other cells in that row would no longer have a background fill.

Attachment 774857

6. ## Re: Conditional Formatting Based on Other Cell

I can't see your attachments, but take a look at the conditional formatting in the attached. It will probably need to be adapted to meet your needs.

7. ## Re: Conditional Formatting Based on Other Cell

Example (see screenshot, attached):
Attachment 774857
This doesn't work !!!

8. ## Re: Conditional Formatting Based on Other Cell

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

There are currently 1 users browsing this thread. (0 members and 1 guests)