Conditionally Format eight cells based on value of first cell

Hi there,

Not sure if this is possible, but I'd like to conditionally format eight cells in a column based on the value in the first column ("Yes" or "No").

Basically, if I write "Yes" into a cell, the cell containing "Yes" and the seven cells below it to change colour.

I've attached a mock-up of how it would look.

Thanks

Hi,

Yes, you can use a conditioning format (CF) for this.

This will take a series of formula's with this format:

Please Login or Register  to view this content.

In the CF it would be applied to this array first:

Please Login or Register  to view this content.

Your CF manager would look like this for the whole sheet:

cf manager.jpg

Each of your three sections would require a different array to be applied to.

Attached is a version of your file showing how this works.

Hope this makes sense and works for you.

Cheers

1. select first range: A3:E10
2. in CF as formula use: =A$3="Yes"
3. set colour

do the same for other ranges, ie in CF: =A$12="Yes" and =A$21="Yes"

repsolv.gif