|
Answer» does any one KNOW how to create a formula with color here is an example of what I am trying to do.
=MIN(J2yellow,L2green,N2blue)
any ideas???You NEED to use "CONDITIONAL Formatting"
Click the cell that you have your formula in.
Click "Format"
Click "Conditional Formatting"
Leave the FIRST drop down box alone.
In the second drop down box select "Equal to".
Click in the third box.
Click in the cell you want to reference. Going by your below example you should now have "=$J$2" in this box.
Click "Format"
Click "Patterns"
Select the color that matches "J2"
Click OK
Click "ADD"
Repeat the above steps for all cells that are part of your formula. Going by your example below you should have three conditions set. 1 for cell J2, 1 for cell L2, & 1 for cell N2.
Once you have added all the needed conditions click OK.
Now if your formula searches all three cells and returns with the lowest value it should also HIGHLIGHT the cell with the appropriate cell color.
|
