Conditional Formatting

**shammy** · 03-04-2010, 06:50 AM

I want to be able to highlight certain cells in a row when a particular input is entered at the beginning of the row.

For example the input choices are;

Left
Right
Up
Down

These could be in any order and multiples of inputs down column A.

If for example 'Right' is entered in cell A2, I would like cells C2:F2 & H2:X2 to be highlighted. BUT equally, I would also like to enter 'Up' in cell A2 and have B2:G2 & P2:S2 highlighted.

I can't seem to get the flexibility of being able to enter any value in Column A and get the corresponding cells highlighted without having to enter 4 formulas in ever cell doen column A - which are a lot of.

**rwgrietveld** · 03-04-2010, 06:56 AM

It seems that you would like to have certain ranges highlighted dependant apon the value in A2.

This is possible with Conditional formatting, but please define:
Left, range ... is highlighted
Right, range ... is highlighted
Up, range ... is highlighted
Down, range ... is highlighted

**shammy** · 03-04-2010, 07:04 AM

Left - I2:N2 & P2:Y2 & AF2:AI2
Right - C2:F2 & H2:X2
Up - AA2:AD2
Down - I2:N2 & AF2:AI2

Each of these inputs is a choice for a single cell (A2). But I would also like to enter any of these inputs in any cell range A2:A100 and get the appropriate cells highlighted in that row.

**rwgrietveld** · 03-04-2010, 07:21 AM

Do these steps:
Select I2:N100 & AF2:AI100
Condition formatting =OR($A2="Left",$A2="Down")

Select C2:F100 & H2:X100
CF =$A2="Right"

Select AA2:AD100
CF =$A2="Up"