Forum Discussion
Applying a set of rules if a condition based on a different column, same row, is satisfied
Hi all! I've been struggling for hours to find an answer but have found nothing. I've found how to apply a rule based on a cell in a different column, but I'm not able to see how to apply a set of ru...
RICARDO JULIO RODRIGUEZ FERNANDEZ
Updated the Cond. Format. rule I earlier shared according to what I understood - Hope this is OK this time
Updated your 2nd rule according to what I suspect you want to get (not sure at all...)
Hi RICARDO JULIO RODRIGUEZ FERNANDEZ
From your picture it seems your data (excluding headers) start in row #2, otherwise adjust 2 below:
- Select your [Expediente] column range
- Home > Cond. Format. > New Rule... > Use a formula to determine which cells to format
Formula:
=$J2 = 1don't forget the $ before J