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
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