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!
RICARDO JULIO RODRIGUEZ FERNANDEZ
In attached Wbook see sheet 'New' where I had to format your data as Table (Benefits of using Tables) + Defined a couple of things in the Name Manager to ensure this will work when new rows are added...
This looks good to me But there's an uncertainty regarding whether (or not) figures in [ects_pass_p] should be considered to calc. the TopN 8 values when [stem] = 0. Currently whatever is in [stem] is taken in account to calc the TopN 8
