Multiple IF function & Conditional formatting.

How about a sample workbook, pictures are nice, but I don't have the time to re-create a workbook from them

The rules for this are pretty straight forward
(>):

Formula:

Please Login or Register  to view this content.

(<):

Formula:

Please Login or Register  to view this content.

(=):

Formula:

Please Login or Register  to view this content.

The only thing that changes between the 3 rules is the comparison operator (ie - '>', '<', '=')
But that does not seem to work for Conditional Formatting; Icons, so, try (I am using Column I for these examples, I left the intermediate steps in to get to the column I formula in, so that you can see how the process works ; feel free to delete all the highlighted columns, they are just to show the arrival method) this;
select column I, Format cells, Font, WingDings, OK (or if you have a specific range, use that and apply font 'Wingdings' (they are usually at the bottom of the font list))
then, this in I3:

Formula:

Please Login or Register  to view this content.

Drag down/extend as far as needed;
select cells for highlighting rules (in attachment, I used I3:I7, because that was the data I put in...use your range to extend this )
then Go CF, 'Highlight Cells Rules','Equal To',
(for larger than):

Formula:

Please Login or Register  to view this content.

(one of the UpArrow displays of 'WingDings' font)
Select a font color/style/etc.., OK

then Go CF, 'Highlight Cells Rules','Equal To',
(for less than):

Formula:

Please Login or Register  to view this content.

(one of the UpArrow displays of 'WingDings' font)
Select a font color/style/etc.., OK

then Go CF, 'Highlight Cells Rules','Equal To',
(for 'No Change'):

Formula:

Please Login or Register  to view this content.

(one of the UpArrow displays of 'WingDings' font)
Select a font color/style/etc.., OK

The reason for this seemingly roundabout way of getting the CF to work is that I cannot find a way to change the font in CF (without VBA, that is), so this is next best thing (and, in some ways better, CF is 'Volatile' by it's very nature, every time the screen updates, it needs to re- check the formatting, I believe my solution on larger sets of data will run a lot faster

(NOTE - In attached, I have created a named range for all the font data that should appear as 'WingDings' ; this was just to make sure everything showed up righty when I changed fonts, to find the right font..again, feel free to delete it)

Hope this helps

EDIT -
NOTE - All the formulas supplied are useful, even the ones you can should/delete, they all use formulas to come to a solurion, so I, would study them carefully before deleting