Hi, I am trying to insert green up arrows and red down arrows in conditional formatting. I have a dollar amount in B6 of $42,715 and a dollar amount in D6 of $46,682. If the dollar amounts in cell B6 is greater than D6, I would like a green UP arrow to display. If the amount is LOWER than the number in D6, then I want to show a red DOWN arrow. The arrows can be displayed in cell C6 if it makes it easier. I can get the rule showing a green up arrow if the number is greater, but I can't figure out how to get the red down arrow if it is lower. I don't see a < option in the rules only a >. To give the background, I am trying to alert my staff with the arrows if their present sales (B6) are up or down from their previous sales (D6). Any help would be greatly appreciated!
Bookmarks