Conditional Formatting

[Brakuz]

Hi guys, I would like to ask you a question.


I would like to format the cell only in the intersections between rows and columns


The cell that crosses the row with a value of 1 and the column with a value of 1 must be colored automatically.

I made a screenshot for example

Any tips/solution would be greatly appreciated.
Cheers!

 

[Scott T]

Select B2:I9
in conditional formatting select new rule then use a formula to determine which cells to format

use

=$A2=B$1

Select formatting
Select OK

 

[Brakuz]

Select B2:I9
in conditional formatting select new rule then use a formula to determine which cells to format

use

=$A2=B$1

Select formatting
Select OK

Thank you so much, very helpful!