Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
For example, I have three columns as follows:
A B C 1 100 120 2 100 80 I'd like to set up a formula applying to the cells in column C. If B1 value is higher than A1 by 10%, C1 will show a word "Up" in green. With this formula C2 will have "Down" in red. Appreciate your help. Thanks, Eli |