R
ryanholliday
Hello,
I would like to conditionally format using the following data and using
3-color icons:
C3=1:43
C4=1:33
C5=1:45
I want to say if (C$3-C4) is greater than 0:02 or less than -0:02, then
format using a green symbol. If (C$3-C4) is greater than 0:05 or less than
-0:05, then format using a yellow symbol. If (C$3-C4) is greater than 0:10
or less than -0:10, then format using a red symbol.
Hopefully this makes sense. I spend a couple hours trying to figure out how
to do this. Thanks in advance for your help!
I would like to conditionally format using the following data and using
3-color icons:
C3=1:43
C4=1:33
C5=1:45
I want to say if (C$3-C4) is greater than 0:02 or less than -0:02, then
format using a green symbol. If (C$3-C4) is greater than 0:05 or less than
-0:05, then format using a yellow symbol. If (C$3-C4) is greater than 0:10
or less than -0:10, then format using a red symbol.
Hopefully this makes sense. I spend a couple hours trying to figure out how
to do this. Thanks in advance for your help!