Results 1 to 6 of 6

On Click Highlights cells

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-28-2015
    Location
    london
    MS-Off Ver
    Microsoft Office 365
    Posts
    116

    On Click Highlights cells

    Hi

    I have cells that I would like to highlight every time I click a cell.

    I have managed to highlight the range of columns and cells when I click on a cell but the problem is I have different groups that would like to do that. What's happening is when I click on a cell it highlights the cells also on the other group.

    A range would be columns and rows. Grouped in different areas of the same sheet and will have a gap in between.

    I have attached the sample to give a clear idea. Conditional formatting is used.

    Thank you very much.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Highlights specific text (not cells) with VBA
    By tmealha in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-28-2018, 07:25 AM
  2. Excel 2007 : 1 click highlights multiple cells?
    By cuutter in forum Excel General
    Replies: 5
    Last Post: 03-22-2012, 04:32 PM
  3. Click a cell but highlights 3?
    By Cmorgan in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 02-16-2012, 07:35 AM
  4. Replies: 1
    Last Post: 03-06-2010, 06:10 AM
  5. Clicking Highlights 3 cells??
    By PRIMERA1 in forum Excel General
    Replies: 6
    Last Post: 08-21-2008, 03:20 PM
  6. Replies: 2
    Last Post: 06-20-2005, 06:05 PM
  7. Replies: 1
    Last Post: 06-20-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1