• Home
  • Excel Formulas
  • Excel Functions
  • Excel VBA
  • Help us Answer Questions
  • Ask a Question
Home / Posts tagged Conditional Formatting

Conditional format cells only that contain a sequence of blanks

Hi all, I need some help trying to nut out a conditional formating formula. I need to only highlight cells that contain 3 or more blanks in sequence in a row …

August 11, 2019 | Excel 2003 Help, Excel Formulas | 103 Comments

Conditional formatting

Hi, I want to highlight whether my “Next Due Date” is in the past or the future , ie. to highlight when the item is overdue. I want the …

August 7, 2019 | Excel 2003 Help, Spreadsheets | 8 Comments

Rules/conditional formatting

Hi,   I am doing a spreadsheet and I need one column (D) to go red and say “Not Ready” if any of the 7 other cells (E to K) in that row are …

February 7, 2019 | Excel 2003 Help, Excel 2010 Help | 1 Comment

Conditional Formatting

I have an excel spreadsheet that takes information from a main sheet and uses formulas to break it down into smaller sheets. I also need it to format the …

January 22, 2019 | Excel 2003 Help, Excel 2007 Help | 6 Comments

Conditional Formatting

Hi there,   I have a roster where i want to implement conditional formatting.   If you see my roster below, you will see the green and red …

January 2, 2019 | Excel 2003 Help, Excel Formulas | 1 Comment

Conditional formatting rules

Hi i’m wondering if and how i can apply the same conditional formatting for multiple words. I need it for the work schedule where multiple people are …

October 24, 2018 | Excel 2003 Help, Excel 2007 Help | 131 Comments

Query related to conditional formatting

Please help me with the formulae . I have a data , where i need to highlight the cells using conditional formatiing .  The criteria is :  Highlight …

August 12, 2018 | Excel 2003 Help, Excel Formulas | 8 Comments

Find different cells in rows that have a matching value

I’m trying to create a conditional format rule along these lines: Highlight if multiple rows have the same value in column A and have …

June 4, 2018 | Excel 2003 Help | 3 Comments

Changing Excel Cells Colour Based on Date

I have a skills matrix for employees that I wish to add a formula to in order to warn us when certain certificates for skills expire. I currently have the …

March 15, 2018 | Excel 2003 Help, Excel Formulas | 12 Comments

Conditional Formatting Excel 2016

I am creating an excel document to help make work easier; I work at a non-profit agency. We have multiple families we serve (over 50). For each family, we must …

November 28, 2017 | Excel 2003 Help, Excel Formulas | 6 Comments

Format column based on values in other columns

This is my data set, I am trying to create a rule that will highlight unique values STATEMENT 1   STATEMENT 2   E 23.73 D 582.7 A 413.47 A 413.47 B …

November 17, 2017 | Excel 2003 Help | 1 Comment

Excel Progress Bar with Conditional Formatting that Changes Color Based on Value

  Basically….. or not so basically as it turns out, I would like create a progress bar in Excel to show the progression towards hitting an incentive …

November 16, 2017 | Excel 2003 Help, Excel 2010 Help | 9 Comments

date range in conditional formatting

Hi I have been trying for days to get the conditional formatting to work, but I just cant. what I need my spreadsheet to do is: Highlight cells Red for …

October 23, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

excel conditional formatting for 2 condition

I have two columns for percentage change in weight and change in thickness, I have to put “ok” if it is range for both mass and thickness and if …

October 14, 2017 | Excel 2003 Help, Excel 2007 Help | 0 Comments

Conditional formating of dates based on days passed

Hello!   I have a column of dates which represents dates of created documents. I want to change the color of the cells with Conditional Formatting in …

October 3, 2017 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Dynamically Adding Table Values

I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, …

August 3, 2017 | Excel 2003 Help, Excel Formulas | 110 Comments

using % in conditional formatting

The question is: The person passes the test if the total is at least 50% OR the person participates in funding( noted as “yes”) When I type the …

July 26, 2017 | Excel 2003 Help, Excel 2010 Help | 9 Comments

Conditonal formatting – date in cell + 14 days

I am trying to find a way to highlight a cell once 14 days of the date in a cell has expired. For example:   Date in cell: 01/06/2017 I want this to …

June 20, 2017 | Excel 2003 Help, Spreadsheets | 5 Comments

Conditional Formatting

Hello! I’m trying to use conditional formatting to do the following task: My worksheet is made of a long list of different names listed in column C, each …

January 8, 2017 | Excel 2003 Help | 0 Comments

How can I conditionally format a cell, base on the contents of a different cell

Hi all, I apologize for the vague title. but I could not think of a way to properly explain the problem in a single line with so few characters… So I was …

November 10, 2016 | Excel 2003 Help, Excel 2010 Help | 0 Comments

Color Background with Conditional Formatting

Sent from my iPad Begin forwarded message:   I’m a previous customer   HAVE AN EXCEL FILE …( a good place to start lol) see enclosed   Looking for the …

July 6, 2012 | Excel 2003 Help, Excel Geek | 14 Comments

Conditional Formating with Multiple Conditions

Hi, I need some help with excel 2007 conditional formating. I have a sheet with payment due dates and a drop down box with a Yes and No option. I want the row …

April 2, 2012 | Excel 2003 Help, Excel 2007 Help | 5 Comments

Conditional Formatting in Excel

Hello, I use Excel 2007. I’m creating a spreadsheet for some guys I look after at work. I manually put in dates that their training expires. I’ve …

July 6, 2011 | Excel 2003 Help, Excel 2007 Help, Excel 2010 Help, Spreadsheets | 171 Comments

Topic Groupings

AND Array chart Colours in Excel Conditional Formatting count countif COUNTIF Function data Date Dates & Times Excel Excel-Vba Excel 2010 Excel Formula Excel Formulas Excel Functions Excel VBA Code filter find formula formulas function functions help IF IF Function index London LOOKUP Macro Macros. match percentage Pivot Table search sort SUM Sum Function SumIf SUMIFS table time VBA vlookup

Pages

  • All Excel Help Posts
  • All Posts
  • Ask a Question
  • Contact
  • Home 8
  • Latest Questions on Excel Geek
  • Post Archive

Categories

  • Excel 2003 Help
  • Excel 2007 Help
  • Excel 2010 Help
  • Excel Formulas
  • Excel Geek
  • Excel VBA
  • Excel VBA Books
  • Favourite
  • Formula
  • Functions
  • Keyboard Shortcut
  • Macros
  • Spreadsheets

Recent Posts

  • Formula to Extract Text from Cell
  • Excel work Lottery prediction
  • Formula Help
  • looking age of last non-matching value
  • solution
© 2014 ExcelGeek. All rights reserved.
Optional footer notes.