Saturday, November 8, 2014

yogi_Conditionally Format Column O For LookingUp Entries In Several Columns In The List In Another Sheet

                 Google Spreadsheet   Post  #1826
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-08-2014
post by  advantagepro:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/b4CCVoWKfTw)
Would it be better to combine these three conditional formats?
I use the following conditional formats on a rather complex spreadsheet which seems to push my computer to the limits.

=NOT(ISERROR(VLOOKUP(B1,INDIRECT("InboundCalls60Days!B:B"),1,FALSE)))
=NOT(ISERROR(VLOOKUP(K1,INDIRECT("InboundCalls60Days!B:B"),1,FALSE)))
=NOT(ISERROR(VLOOKUP(L1,INDIRECT("InboundCalls60Days!B:B"),1,FALSE)))

I'm wondering if it would be better to somehow combine this formula into one to reduce load and, if so, does anyone know how I can do that?
---
hanks but I don't think that formula works like I need it. Look at my sheet https://docs.google.com/a/advantageproservices.com/spreadsheets/d/103hs0tzws77_4SzvZ9lX_RRk5wpiSMAspLpF0_JPWKQ/edit#gid=0

Column O uses three separate conditional formats and returns the results I need.

Column N uses the combined formula you provided. 
--------------------------------------------------------------------------------------------------------------------------------
I can not say whether there is computational efficiency wise an advantage in combining different formulas into a single formula ... however the following solution is with a single formula