Hi all. I'm trying to set up conditional formatting on a budget spreadsheet and I'm not sure if what I'm looking to do is possible.
Objectives:
1. Compare values in Column N to values in Column F
2. If values in Column N are within 2% of the values in column F, fill the cell in Column N "green"
3. If values in Column N are between 2% and 4% of the values in column F, fill the cell in Column N "yellow"
4. If the values in Column N are not within 4% of the values in column F, fill the cell in Column N "red"
If Possible:
Add a smiley face to the end of the figure in Column N if the cell is colored "green"
Add a meh face to the end of the figure in Column N if the cell is colored "yellow"
Add a frowney face to the end of the figure in Column N if the cell is colored "red"
If the above isn't possible:
Add a smiley face to the cell in Column O if the cell next to it in Column N is "green"
Add a meh face to the cell in Column O if the cell next to it in Column N is "yellow"
Add a frowney face to the cell in Column O if the cell next to it in Column N is "red"
*Column N already has a formula (cell in Column K divided by cell in Column L*
Objectives:
1. Compare values in Column N to values in Column F
2. If values in Column N are within 2% of the values in column F, fill the cell in Column N "green"
3. If values in Column N are between 2% and 4% of the values in column F, fill the cell in Column N "yellow"
4. If the values in Column N are not within 4% of the values in column F, fill the cell in Column N "red"
If Possible:
Add a smiley face to the end of the figure in Column N if the cell is colored "green"
Add a meh face to the end of the figure in Column N if the cell is colored "yellow"
Add a frowney face to the end of the figure in Column N if the cell is colored "red"
If the above isn't possible:
Add a smiley face to the cell in Column O if the cell next to it in Column N is "green"
Add a meh face to the cell in Column O if the cell next to it in Column N is "yellow"
Add a frowney face to the cell in Column O if the cell next to it in Column N is "red"
*Column N already has a formula (cell in Column K divided by cell in Column L*