The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

Applying if functions over conditional formatting

Applying if functions over conditional formatting

0
Votes
2
Answer

Hi,

  1. Can I apply “If” Functions over conditional formatting? 
  2. Are there any limitations regarding several equations applying to a single function? or how many equations can I apply to a single function? 

TIA.

2 Answers

365 Team
0
Votes

Hello,
Formatting and functions are two different things.
Having said that conditional formatting contains plenty of logics that can be incorporated in your formatting choices.
Best,
Ned

0
Votes

whilst as Ned says, conditional formatting contains plenty of logics that can be incorporated in your formatting choices, it can be very tricky when starting with these to write custom formulas into conditional formatting rules, which I am guessing is what you are asking here?
My advice is one, google a specific type of conditional formatting rule you wish to apply to see how it is done, there is usually someone somewhere who has done it before, or two, trial and error, by first writing the argument in a regular Excel cell and testing it, before then copying it into the conditional formatting rule. but even then, that isn’t always straightforward.
Hope that makes sense and hope it helps answer the question you were asking?

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF