Highlighting a range of cells in a row using a conditional format

[Anthony]

Is there a way to only highlight a range of cells in the row if a condition
exsists rather than the entire row? For instance row 1 contains data from
A1:J1. If a condition exsists in A1 only highlight A11 and if the condition
exsists in G1 only highlight G1:J1

 

[Frank Kabel]

Hi
try the following:
- select A11
- enter your condition. e.g. the formula
=$A1=1
- repeat for cells G1:J1

 

[Anthony]

Thanks Frank, but I would like to highlight the range of cells with a color
(yellow) if the contants of lets say A1 contain any combination of (1) (2) or
both.

 

[Frank Kabel]

Hi
not really sure what you want to check. What do you mean with this
combination?

 

[Frank Kabel]

Hi
then just change the condition to:
=($A1=1)+($A1=2)

or if you have these values in brackets use.
=($A1="(1)")+($A1="(2)")