Forum Discussion
Solved
Conditional Formatting
I am having some trouble with conditional formatting. I have a data set in excel and I would like 2 or 3 conditions to apply to all of the respective points. These are the conditions: If Alpha < ...
I think you only need two rules, one for blue and another for red, the rest will be black by default.
You may try following formulas to make conditional formatting rules...
For Blue:
=AND($G7>-0.85,$I7>0.1)
For Red:
=AND($G7>-0.85,$I7<0.1)
I think you only need two rules, one for blue and another for red, the rest will be black by default.
You may try following formulas to make conditional formatting rules...
For Blue:
=AND($G7>-0.85,$I7>0.1)
For Red:
=AND($G7>-0.85,$I7<0.1)
Than you! At first, I could not tell if you changed anything, but I saw how you applied to to the whole column.
This really helped me out.
This really helped me out.
You're welcome Jonezy256! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.