Dynamic Conditional Formatting

[fischXcell2]

Hello,
I'm embarrassed that I can't figure this out for myself, but......

This is a small sample of a larger worksheet.
I've been trying all day to create a dynamic conditional formatting. I want to change the fill color based on the value Typ, but I only want to fill the first 3 columns. I don't want to fill Matrix or ADS.

I created two dynamic ranges using OFFSET - One for Typ and one for the first 3 rows called CompDetails.

I want to create dynamic conditional formatting that will make the first 3 rows blue if Typ = Desktop; green if Typ = Laptop and so on.
For Typ =OFFSET(Computer!$A$1,1,,COUNTA(Computer!$A$1:$A$999)-1,1)
For CompDetails =OFFSET(Computer!$A$1,1,,COUNTA(Computer!$A$1:$E$999)-1,3)
The worksheet will expand down, but not across.

I know there is a way to use a formula to do this, but I cannot for the life of me figure it out.

Please help before I tear out all of my hair!! I won't look good bald.

	TYP​	MODEL​	ORT​	MATRIX​	ADS​
1	Desktop​	HP Compaq​	UNBEK​	JA​	JA​
2	Desktop​	HP Elite 7000 Microtower​	UNBEK​	JA​	JA​
3	Desktop​	HP 500B​	KELLER​	NEIN​	NEIN​
4	Laptop​	Fujitsu U7411​	KELLER​	NEIN​	NEIN​
5	Laptop​	Fujitsu U7310​	UNBEK​	JA​	JA​
6	Laptop​	Lenovo Thinkpad E570​	KELLER​	JA​	JA​

**I cannot use VBA**

 

[etaf]

i maybe misunderstanding this

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B2:D10000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($B2 <> "" , $B2="desktop")

Format [Number, Font, Border, Fill] - fill Blue
choose the format you would like to apply when the condition is true
OK >> OK

repeat for the other rules
=AND($B2 <> "" , $B2="laptop")
format fill green

BUT i maybe misunderstanding this

 

[fischXcell2]

i maybe misunderstanding this

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
B2:D10000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND($B2 <> "" , $B2="desktop")

Format [Number, Font, Border, Fill] - fill Blue
choose the format you would like to apply when the condition is true
OK >> OK

repeat for the other rules
=AND($B2 <> "" , $B2="laptop")
format fill green

BUT i maybe misunderstanding this

OMG!! That worked. I tried using AND before, but I must have made a mistake in the formula somewhere because it didn't work. Thank you so much!! I'll be able to sleep tonight!

 

[etaf]

you are welcome