CODEWITHSUNDEEP
excelrowcelltransposeconditional-formatting
user16977469
user16977469

Reputation: 3

Cell conditioning based on cell value on a row to cell value on column

Rows and Columns Pic

Above is the cell values I want to apply the condition too.

A solution that works is to create a new column using the transpose function for the row in Question is to use the cell = cell.

I dont want to add another column id rather just take that row and add condition based on the columns 1x1

Upvotes: 0

Views: 53

Answers (1)

cybernetic.nomad
cybernetic.nomad

Reputation: 6418

You could INDEX the row to do this:

=INDEX($B$2:$I$2,ROW()-2)=J3

Example: enter image description here

Note: you may need to adjust the number you substract depending on where your table starts on the sheet.

Upvotes: 1

Related Questions