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 rules to the cells in a column that satisfy a condition in a different one. See below:
How could I apply a set of rules to each cell on column Expediente only when stem = 1?
Thanks in advance!
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
LorenzoThanks! Yes, I can understand how I can apply a format rule to a column based on the values of a different one. But how can I apply formatting rules only when satisfying a condition? See below.
I want the formatting rules applied to column L [average] to affect only the rows with [stem] = 1. Is that possible? Thanks!
RICARDO JULIO RODRIGUEZ FERNANDEZ
I want the formatting rules applied to column L [average] to affect only the rows with [stem] = 1. Is that possible?
What I provided should do it but your picture seems to indicate you already have other Cond. Format. rules applied on column [average]. Suggestion: delete any existing Cond. Format. rules that currently applies on the [average] column then apply what I suggested
If still not good please attach a sample workbook + a picture showing the expected result. Thanks
