Aug 10 2021 06:18 PM
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 < -0.85, then I would like the numbers to be black.
If Alpha > -0.85 and Charlie > 0.1, then I would like the numbers to be blue.
If Alpha > -0.85 and Charlie < 0.1, then I would like the numbers to be red.
I can get these conditions to apply to a single cell for each data point, but I would like to be able to apply them to all the points at the same time with respect to each other. It would save copious amounts of time to be able to apply them to the whole data set.
If I could have some help that would be great.
Thanks
Aug 10 2021 08:17 PM
SolutionI 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)
Aug 12 2021 08:30 AM
Aug 12 2021 10:56 AM
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.
Aug 10 2021 08:17 PM
SolutionI 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)