Forum Discussion
Applying a set of rules if a condition based on a different column, same row, is satisfied
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
Lorenzo Thanks! I think the way you suggest will be more straightforward: I'm attaching a dummy spreadsheet with a single conditional format applied to column F, [ects_pass_p]. Based on the value of the cells A7 and A21, [stem] = 0, I want the conditional formatting set to column F not to affect the cells F7 and F21.
Is that possible? How? Thanks!
