software

Hi all,
I hope I don't confuse anyone...
Small sample of my spreadsheet belowCol A(Features) Col B (Cond.Calculation of Col C) Col C (EndsWith)
HOLE_1.X =IF(C5=quot;TPquot;,datadump!HL5,datadump!C5)
=RIGHT(A5,2)HOLE_1.Y =IF(C6=quot;TPquot;,datadump!HL6,datadump!C6)
etc...
HOLE_1.DF =IF(C7=quot;TPquot;,datadump!HL7,datadump!C7)
HOLE_1.TP =IF(C8=quot;TPquot;,datadump!HL8,datadump!C8)
HOLE_1.B =IF(C9=quot;TPquot;,datadump!HL9,datadump!C9)
I am trying to conditional format Col B by the result of the first logical
test, not by the formula result. So when the first statement is quot;TRUEquot; (IF
C5=quot;TPquot; (TRUE))
the format should read the first TRUE or FALSE answer, not the actual result
of the formula.
Also, I am trying to conditional format a row on the result of Col A
quot;EndsWithquot;
So if the feature in column A ends with .X, format entire row yellow(e.g.)
If feature ends with .Y , format entire row differernt color etc...

TIA
=IF(D5=quot;TPquot;,datadump!HL5,datadump!C5)



quot;ufo_pilotquot; wrote:

gt; Hi all,
gt; I hope I don't confuse anyone...
gt; Small sample of my spreadsheet below
gt;
gt;
gt; Col A(Features) Col B (Cond.Calculation of Col C) Col C (EndsWith)
gt; HOLE_1.X =IF(C5=quot;TPquot;,datadump!HL5,datadump!C5)
gt; =RIGHT(A5,2)HOLE_1.Y =IF(C6=quot;TPquot;,datadump!HL6,datadump!C6)
gt; etc...
gt; HOLE_1.DF =IF(C7=quot;TPquot;,datadump!HL7,datadump!C7)
gt; HOLE_1.TP =IF(C8=quot;TPquot;,datadump!HL8,datadump!C8)
gt; HOLE_1.B =IF(C9=quot;TPquot;,datadump!HL9,datadump!C9)
gt;
gt;
gt;
gt; I am trying to conditional format Col B by the result of the first logical
gt; test, not by the formula result. So when the first statement is quot;TRUEquot; (IF
gt; C5=quot;TPquot; (TRUE))
gt; the format should read the first TRUE or FALSE answer, not the actual result
gt; of the formula.
gt; Also, I am trying to conditional format a row on the result of Col A
gt; quot;EndsWithquot;
gt; So if the feature in column A ends with .X, format entire row yellow(e.g.)
gt; If feature ends with .Y , format entire row differernt color etc...
gt;
gt; TIA
gt;
gt;
gt;
gt;
gt;
gt;
gt; =IF(D5=quot;TPquot;,datadump!HL5,datadump!C5)

Well, I figured out the ENDSWITH cond.formatgt; formula isgt;
=RIGHT(A8,2)=quot;TPquot;

I have done this before too, quot;I have a full 6-pack, just the plastic thingy
that holds them all together was missingquot;
LOL

Still need to figure out the IF TRUE thing now...