Wednesday, February 19, 2014

yogi_Conditionally Format Column A In Sheet3 For Matching SKU Values In Column A Of Sheet1 or Sheet2 (cell color only ... sorry can't bold)

                                         Google Spreadsheet   Post  #1537
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-19-2014
post by Gray Bouchard (https://productforums.google.com/forum/#!msg/docs/bnU0yH9QASc/e9wV5H3oFrAJ)
Conditional Formating (bold) in sheet if a value appears in two DIFFERENT sheets
OK, this might be a simple fix, but I'm a bit stumped.

I have a worksheet with three active sheets, 

Sheet 1 = "Active"
Sheet 2 = "Sold"
Sheet 3 = "Master List"

Column A in all sheets is SKU numbers. 

I want a script where the rows in Sheet 3 that feature a value (a SKUs) that appear in EITHER Sheet 1 or 2 are bolded (and the font color changed to red if possible). That is to say, I'd like to highlight a value in Sheet 3 that appears in ether Sheet 1 or 2.

Thanks for the assistance, let me know if any additional details/clarification is needed. 
-------------------------------------------------------------------------------------------------------------------------------------------------

using formula base approach for Conditoinal Formatting in Google New Sheets I can color the cells but not make them bold









No comments:

Post a Comment