Clounce.comClounce.com

An innovative view into technology

  • Privacy & Cookies
  • Who is Clounce?

Categories

  • .NET (19)
  • Arduino (1)
  • Chemoinformatics (4)
    • Similarity (2)
    • Virtual Screening (1)
  • Cloud (4)
    • AWS (1)
    • Azure (2)
  • Elgg (2)
  • Flutter (1)
  • Magento (13)
    • Magento 2 (5)
  • Mathematics (3)
  • MS SQL (3)
  • Office (4)
    • Excel (4)
  • Other (13)
  • Powershell (4)
  • R Language (3)
  • Sitecore (4)

Sponsors

Category: Office

Highlight a set of rows in Excel based on date range

October 26, 2016 by Joseph D'Emanuele·0 Comments

Hi, in this blog we take a look how we can highlight a set of rows in Microsoft Excel that fall between two dates.  This is inspired from Rodel Balasabas comment in my other post about highlighting a row in Excel. Thanks!   The final product looks as:   Adding multiple conditions to Excel’s conditional … Continue reading Highlight a set of rows in Excel based on date range

Automatically mark the current week in an Excel Chart

November 2, 2010 by Joseph D'Emanuele·0 Comments

Last time we discussed how to highlight a row in Microsoft Excel automatically. This can be accessed here. Today we will discuss how to highlight a particular entry in a Microsoft Excel chart. The final result is shown in Figure 1. To demonstrate how the above is achieved, we will use the following data: Step … Continue reading Automatically mark the current week in an Excel Chart

Highlight a row in Excel based on a cell value

October 18, 2010 by Joseph D'Emanuele·3 Comments

In this blog entry we take a look how to highlight a row in a Microsoft Excel table based on a cell value.  First we take a look at the steps required and then we take an example to see it in practice.   We will use the “Conditional Formatting” feature of Microsoft Excel. Steps to … Continue reading Highlight a row in Excel based on a cell value

How to link a cell value with a an Excel drop down list

August 9, 2010 by Karlston D'Emanuele·2 Comments

The article shows a simple way of how to create a drop-down list and proceeds to show how cell values can be changed when the list item selected is changed.

COPYRIGHT © 2010-2018 CLOUNCE.COM. WEB SITE POWERED BY WORDPRESS CMS

We are using cookies on our website

Our website uses cookies for Google Analytics, Google AdSense and Disqus. The information collected is anonymous and only used to understand the usage of the website. Please confirm, if you accept our tracking cookies. You can also decline the tracking, so you can continue to visit our website without any data sent to third party services.

Our Privacy & Cookies Policy