Formula as text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yanto hendrawan - 02 Jan 2006 06:15 GMT

Happy new year..

Why C2 cell as the result of VLOOKUP which contains "APPLE" can be rea
by D2 as formula which cause D2 becomes "RED" unless in cell C2 type
"APPLE"?

Rgds

Y

Reply to this Message

Bob Phillips - 02 Jan 2006 11:01 GMT

Use Conditional Formatting

Select column A
Menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$C$2="APPLE"
Click the Format button
Select the Pattern Tab
Select the red colour
OK
OK

Signature

HTH

RP
(remove nothere from the email address if mailing direct)

> Happy new year..
>
[quoted text clipped - 5 lines]
>
> YH

Reply to this Message