Conditional Formatting Multiples Ranges

[JeannetteE]

HI,

I'm trying to conditionally format a range of cells based on a single cell value in each range.

I have 10 Ranges in Column C, Range C23:C32, if C23 contains "MI" then it fills all cells in the range with a color,
or if C23 contains "P1" then it is a different color, if it contains anything else it stays the default color.
The next range is C33:C42 etc

This then needs to be applied from column C to Column PF, where the Range for column D is then D23:D32 and D23 contains "MI" etc.
I would prefer to do it directly in the spreadsheet but if need be can do it in VBA.

Any help would be greatly appreciated.

 

[pgc01]

Hi

Use conditional format on C23, like for the first condition use the formula

=(C$23="MI")

Then apply it to $C$23:$PF$23

 

[JeannetteE]

Hi

Use conditional format on C23, like for the first condition use the formula

=(C$23="MI")

Then apply it to $C$23:$PF$23

Thanks for the reply that only applies the color if C23 = "MI" whereas I need Contains or Starts with.

 

[Special-K99]

Try

=(ISNUMBER(SEARCH("MI",C$23)))

 

[JeannetteE]

Hi

Use conditional format on C23, like for the first condition use the formula

=(C$23="MI")

Then apply it to $C$23:$PF$23

Thank you pgc01, I've used what you gave me and changed the Formula to =FIND("MI", C$23) and that worked a treat.

 

[pgc01]

I'm glad it helped.

Sorry for not reading you post more carefully.