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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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, …
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 …
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 …
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 …
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 …
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 …
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 …
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 …