maglorluinwe
New member
- Joined
- May 30, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi everyone.
I've been googling for a long time and I can't find an answer to what I've been looking for.
Let's put the things simple: I would like a tutorial on how to use formulas on conditional formatting. Simple, right? But I can't find it anywhere... at least not the way I would like to find...
usually I find only examples of especific formulas, but none of them explains, for example, why I put "=B2 < 100", or how to use correctly the "IF" formulas, or even how can I apply a conditional formatting to a table that, if it changes size (by adding more table lines), so the created rule automatically would apply to these new added lines; no one explains HOW TO CREATE the formulas from zero.
The things I found until now only tell me that, in short, I shall put in things that I can't understand one hundred percent...
Don't get me wrong, although... I understand how to use formulas, I even change recorded macros to get especific results, so I am not a newbie... but I REALLY need a complete explanation regarding using formulas on conditional formatting, so I can create my own formulas understanding key concepts of what to do and what not to do... I need a friendly tutorial on sintax of formulas on conditional formatting and that is that...
Thanks!!
I've been googling for a long time and I can't find an answer to what I've been looking for.
Let's put the things simple: I would like a tutorial on how to use formulas on conditional formatting. Simple, right? But I can't find it anywhere... at least not the way I would like to find...
usually I find only examples of especific formulas, but none of them explains, for example, why I put "=B2 < 100", or how to use correctly the "IF" formulas, or even how can I apply a conditional formatting to a table that, if it changes size (by adding more table lines), so the created rule automatically would apply to these new added lines; no one explains HOW TO CREATE the formulas from zero.
The things I found until now only tell me that, in short, I shall put in things that I can't understand one hundred percent...
Don't get me wrong, although... I understand how to use formulas, I even change recorded macros to get especific results, so I am not a newbie... but I REALLY need a complete explanation regarding using formulas on conditional formatting, so I can create my own formulas understanding key concepts of what to do and what not to do... I need a friendly tutorial on sintax of formulas on conditional formatting and that is that...
Thanks!!
Last edited: