Conditinal Formatting question

[wbco]

Hi Everyone,

I'm trying to highlight a range of cells based on one of those cells containing certain text.

I see in Excel that I can use the conditional formatting button to highlight one particular cell's background color based on certain text, but I'd like to highlight a range of cells.

Any ideas?

Thank you in advance for any help.

 

[Joe4]

Yes, that can be done by using the Formula option and use Absolute Referencing in your range references.

If you need help doing this, please provide details.

 

[wbco]

Hmmm,.... yes I would need help.

So basically if cell D23 has a "Y" in it, I need to have D15 thru D58 highlighted with a yellow background.

Again, thank you for any help you can give.

 

[Joe4]

Select cells D15:D58.
Then go to Conditional Formatting, select the Formula option, and enter this formula:

=D$23="Y"

and choose your yellow background option.

The key is to use the Absolute Reference signs ($) to lock the row at D23, so it won't move as Excel moves through the cells.

See here for an explanation of Absolute/Mixed/Relative range references.

 

[wbco]

Ahhh perfect! Thank you!

 

[Joe4]

You are welcome!