# ConditionalFormat-EndsWith, and logical Test IF

1. ## ConditionalFormat-EndsWith, and logical Test IF

Hi all,
I hope I don't confuse anyone...
Small sample of my spreadsheet below

Col A(Features) Col B (Cond.Calculation of Col C) Col C (EndsWith)
etc...

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 "TRUE" (IF
C5="TP" (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
"EndsWith"
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

2. ## RE: ConditionalFormat-EndsWith, and logical Test IF

"ufo_pilot" wrote:

> Hi all,
> I hope I don't confuse anyone...
> Small sample of my spreadsheet below
>
>
> Col A(Features) Col B (Cond.Calculation of Col C) Col C (EndsWith)
> etc...
>
>
>
> 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 "TRUE" (IF
> C5="TP" (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
> "EndsWith"
> 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
>
>
>
>
>
>

Well, I figured out the ENDSWITH cond.format> formula is>
=RIGHT(A8,2)="TP"

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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1