I have around 400 values in each cell A2 and A3. Now I want to change the font color of each values in A3 based on values in A2 with some conditions. If the value in A3 is equal to value in A2 then color should be black, if value in A3 is greater than A2 then color should be red and if value in A3 is less than A2 then color should be green.
Can it be done with Conditional Formatting?
If yes, then please tell me how to do it?