Forum Discussion
Stuck with Conditional Formatting
I've searched high and low and not getting anywhere I need. It's probably so simple but I just can't get it to work. I've got a training matrix document. I need a column to adjust the color base...
This is actually perfect! If I understood a little about how it worked.
Is it possible to just break down the formula (still relatively new to conditionals) so I understand what's going on as such? For instance, I'd need to change the C value for the B column right?
Is it possible to just break down the formula (still relatively new to conditionals) so I understand what's going on as such? For instance, I'd need to change the C value for the B column right?
That's correct, you would change the C2 to B2 when you type the two-year formula, as well as changing 1095 to 730.
The portion (C2<>"") prevents the formatting from being applied to blank cells. The remaining portion calculates the expiry date (C2+1095) and subtracts that from the current date ( TODAY() ) to see how many days away that is.
The portion (C2<>"") prevents the formatting from being applied to blank cells. The remaining portion calculates the expiry date (C2+1095) and subtracts that from the current date ( TODAY() ) to see how many days away that is.
- This might be my brain being a little smooth at the moment but how come for each different cell all the formula reference C2 in the example above? Wouldn't it be different for each sequential cell? I.E C2 / C3 / C4 / C5 .... Or because we're applying the formula to the group of cells it just takes the original one and copies the formula onto the range of cells?
CosTech1955 Yes, the formula does need to be different for each cell to which it is applied. This works because
it's magic... Excel modifies the references to other cells as needed without showing that change to you.[Edited for clarity]