Bold matching cells based on conditional formatting

[hviking]

I've got a list of items (See list at the end)

If I answer Yes in Column C, then Column B turns bold. This is no issue, however, I would like for all matching Office Buildings to also turn Bold. Is this possible without VB or scripting?
(The actual list has 200+ names and 100 Buildings)

User Name A	Office Building B	Upgraded Building C
Peter	C1481
Paul	C1498
Mary	C1481	Yes

 

[etaf]

i think this will do what you are after
=AND(COUNTIFS($B$2:$B$29,B2,$C$2:$C$29,"yes"),COUNTIF($B$2:$B$29,B2))

Book7
	A	B	C	D	E
1	User Name A	Office Building B	Upgraded Building C
2	Peter	C1481			TRUE
3	Paul	C1498			FALSE
4	Mary	C1481	Yes		TRUE
5		C1481			TRUE
6		C1498			FALSE
7					FALSE
8					FALSE
9					FALSE
10					FALSE
11					FALSE
12
Sheet1

Cell Formulas
Range	Formula
E2:E11	E2	=AND(COUNTIFS($B$2:$B$29,B2,$C$2:$C$29,"yes"),COUNTIF($B$2:$B$29,B2))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B30	Expression	=AND(COUNTIFS($B$2:$B$29,B2,$C$2:$C$29,"yes"),COUNTIF($B$2:$B$29,B2))	text	NO

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

Highlight applicable range >>
B2:B300 - 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(COUNTIFS($B$2:$B$300,B2,$C$2:$C$300,"yes"),COUNTIF($B$2:$B$300,B2))

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

 

[hviking]

That is perfect. Thank you

 

[etaf]

you are welcome, hopefully it works as well in your REAL data