Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Forums application. See all tags in the site
  • Conditional Formatting

    I am sure this has been explained before and i am sorry to ask again but my search has not seemed to have answered my question. So column A1 starts with the #8 and has a range from 1-20. Column B1 starts with the #2 and also has range of numbers from 1-20. selected B1 which is the 2. I conditionally...
    Posted to Functions and Formulas (Forum) by Ryan on Wed, Aug 13 2014
  • Help on If Then Else

    I am creating a simple spreadsheet. I would like to autopopulate a 'table' in the spread sheet with specified names if they are in group A, B, C or D. This is what I have: Group # Names 1 Sally Mae 2 Susie Que 2 John Doe 3 Dick Tracy 1 Edgar Allen Poe 2 John Dillon 2 Jack Sprat 3 Sylvester Stallon...
    Posted to Functions and Formulas (Forum) by MAlberthal on Fri, Aug 1 2014
  • conditional formatting - keep columns static

    Good afternoon all! This looks like a great site so far, and I have already had a question answered by googling before my sign up. Cheers! What I am looking for is a little help with conditional formatting. In the attached screenshot, I have a column 'H' of which references cells from B,E,F and...
    Posted to Functions and Formulas (Forum) by Steven Potter on Sun, May 4 2014
  • Re: Highlight a cell if contents are not from a list.

    I would guess you'd define your Conditional Formatting formula something like: =ISERROR(MATCH("This Cell","The List Range",0)) obviously substituting in the appropriate range references. Let us know how you go.
    Posted to Excel 2007 and 2010 (Forum) by Rick Williams on Wed, Mar 19 2014
  • Re: how to colur column based on a cell value

    You would be better off to use Conditional Formatting. Select the cells you wish to change colour (i.e. F8:AJ500) Home Tab > Conditional Formatting > New Rule Select the last option "Use a formula to determine which cells to format" Enter the formula =F$7="SUNDAY" Click the...
    Posted to Excel 2007 and 2010 (Forum) by Rick Williams on Mon, Jan 13 2014
  • Re: Copy conditional formatting to a whole column

    The first thing I'd suggest is to clear all conditional formatting from the sheet as you may have several overlapping or conflicting formatting rules in place. Home > Conditional Formatting > Clear Rules from Entire Sheet / Selection Then select all the cells you'd like to have the rule...
    Posted to Functions and Formulas (Forum) by Rick Williams on Wed, Oct 16 2013
  • Copy conditional formatting to a whole column

    Hi! I am not an Excel Guru so please hangle my question as coming from someone who has never used excel beyond doing some very easy summing up and managing a household's expenses level. I have a sheet with about 10 columns. In the last cell of each row that is J2 for the 1st row I have the following...
    Posted to Functions and Formulas (Forum) by zoktolk on Mon, Oct 14 2013
  • NAME HIGHLIGHT PROBLEM

    HI ALL, I HAVE A PROBLEM RELATED TO CONDITIONAL FORMATTING. I HAVE A TEAM ARROUND 60 RESOURCES TO WORK ON PROJECT. MY PROBLEM IS HOW TO MARK THE NAME WHOSE ON THE PROJECT AND PRESENT ON THE JOB. I CREATE A ATTENDANCE WORK SHEET IN WHICH COLM "A" HAS NAME, COLM "B" HAS "PRESENT"...
    Posted to Functions and Formulas (Forum) by CHARANJIT on Tue, Jul 30 2013
  • Excel macro to conditionally highlight a tab when a text string is entered into a column

    Hello, I was having difficulties writing a macro that conditionally highlight a tab in yellow if a text string is enterred into a column. This macro works will work just like the conditional formatting feature of Excel does. Your help would be very much appreciated. Thanks.
    Posted to VBA (Forum) by haibiz9 on Sun, Oct 7 2012
  • newbie on Conditional Formatting

    Hello, I'm new to excel 2011 (mac) and conditional formatting. I would like to color format the cell containing the lowest value in a given column and only color it if no other cells in that column have the same value. Any help/direction would be greatly appreciated. Thank you! RD
    Posted to General (Forum) by rogerdodger on Mon, Mar 19 2012
Page 1 of 3 (27 items) 1 2 3 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.