Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How Can I Do This?
In sheet1, A1 value = 10, B1 value = 5 (both vary, sum of numbers on another
sheet) I would like to have another cell (we'll call it Difference) that determines which is greater (A1 or B1) and if A1 is greater, then color this result in red and calculate A1-B1. However, if B1 is greater, keep the default color and calculate B1-A1. Is this possible with function(s)? Don |