Conditional Formatting with Macros or VBA?

[ken_spyce]

Hi, I have a computer inventory sheet that I need to update as a justification for next year's purchases. This company I work in still uses a few Pentium I and Pentium II PCs. I want to use conditional formatting that would apply for the whole row and the criteria (Processor Used?) is in Column K. My data range is between A4 to BF156.
To be precise, if I say Pentium I or Pentium II in column K it should change the formatting of the whole row where the Pentium I PC belongs.

 

[Bruno_x]

Hi Ken,

You need a formula that returns a logical "TRUE" or "FALSE".
If cell K4 contains the text like "Pentium I", "Pentium II" ,"Celeron", "Pentium IV", etc., try something like this :

Select all the rows and the columns A:K
and use conditional formatting with this formula :
=OR($K4="Pentium I" ,$K4="Pentium II")

Regards,

 

[ken_spyce]

Another question...
can we use wildcards here in this case?

 

[Bruno_x]

Hi Ken,
In that case I would use LEFT :

=LEFT($K4,7)="Pentium"

Hope this helps...