---
title: "Discussion on \"Multiple Languages highlighting\" | Hashnode"
description: "Discussion on \"Multiple Languages highlighting\". Excel Formulae\nI5=SUMPRODUCT(--(C5:C14=\"red\"),F5:F14)\nI6=SUMPRODUCT(--(B5:B14=\"tx\"),--(C5:C14=\"red\"),F5:F14)\nI7=SUMPRODUCT(--(B5:B14=\"co\"),--(C5:C14=\"blue\"),F5:F14)\n\nBASIC\nDim wb as workbook\n\nFor Each wb In Application.Workbooks\n    If not wb.ReadOnl..."
url: "https://hashnode.com/posts/multiple-languages-highlighting/6464f7a4af38fca629b7b9ce"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Multiple Languages highlighting](https://testprod.hashnode.dev/multiple-languages-highlighting?utm_source=hashnode&utm_medium=feed)

Excel Formulae I5=SUMPRODUCT(--(C5:C14="red"),F5:F14) I6=SUMPRODUCT(--(B5:B14="tx"),--(C5:C14="red"),F5:F14) I7=SUMPRODUCT(--(B5:B14="co"),--(C5:C14="blue"),F5:F14) BASIC Dim wb as workbook For Each wb In Application.Workbooks If not wb.ReadOnl...

May 17, 2023 · 2 min read · testprod.hashnode.dev  
Read the article

## Written by

[Sai Krishna Prasad Kandula](https://hashnode.com/@sai_krrishhh)

@sai\_krrishhh

  
[View profile](https://hashnode.com/@sai_krrishhh)

Sr Software Engineer @hashnode | I write about ReactJS, JavaScript, Ruby on Rails as I learn | Let's share and learn together💖

I am a Self-Taught and Passionate FullStack Developer from Bangalore, India. ReactJS, JavaScript, Ruby on Rails, HTML, and CSS.

## Responses 1

Markdown supported · ⌘↵ to post

[Sai Krishna Prasad Kandula](https://hashnode.com/@sai_krrishhh)

[Jun 2, 2023](https://hashnode.com/posts/multiple-languages-highlighting/6464f7a4af38fca629b7b9ce/comment/647a1697eafd38ddc2c9328c)

C1

[Sai Krishna Prasad Kandula](https://hashnode.com/@sai_krrishhh)

[Jun 2, 2023](https://hashnode.com/posts/multiple-languages-highlighting/6464f7a4af38fca629b7b9ce/comment/647a1697eafd38ddc2c9328c#reply-647a16a568c73be8bfc41955)

R1