condition formatting

I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday...

Experts, I have an action plan template i'm attempting to use in which there is a conditional formatting set to turn the row yellow if the action is within 7 days of the targeted completed date. I have column heading for "targeted date" and =today() in cell C1. My conditional formatting is done...

Hi. If someone can please give me some advice, that will be grand. D7:D16 say either "POUND", "PERCENTAGE", OR 'NUMBER'. E7:E16 say a number ranging between 0.01 and 10000000 I effectively want to code in VBA so that E7:E16 will be formatted corresponding to the adjacent text string. So, if...

I have a gantt chart that I like and understand how to update the information. What I am looking for is how to roll up all the sub task conditional formatting to the mask task line. Example Gantt: <tbody> Start End Main Task Y Y - - - Y Y Y - - - Y Y Y SubTask 1...

Hello,need help with something simple but rather complex for me. i have a large list of 3 digit numbers in Column A. ex.(123)..I would like each digit separated in its own column (text to column) i would like these copied in a series of 3 with a space of 2 rows in between each series. Each...

Hey all, Need some advice. I have a spreadsheet of number data with dates in ascending order in the first left column. I want to apply a format so that for example: If the number in Cell B3 is greater than the number in B2 (turn the text red) If the number in Cell B3 is less than the number...

Good day Basically I want to fill the color of the column if the heading is Saturday or sunday. That is step one. Step two is I want to have the average of each day. <tbody> mon tues wed thurs fri sat sun mon average monday tues wed 1 July 2 July 3 July 4 July 5 july 6 july 7 july 8...

Hello all, I have two columns. Column A (2:500) is a due date calculated by a formula Column B (2:500) is the actual date of completion. I have conditional formatting in Column A as the date gets closer (yellow 1 month out, orange 1 week out, red this week). The problem is, the conditional...

Hey everyone, In column 'G' I have set up a 3 point colour scale based on the date. I want some of these cells to be excluded from this calculation based on the corresponding cell in column 'E'. So the rule I'm trying to create should go something like this: If E5 = "Action Taken" Exclude G5...

Ok im a newbie with Excel. My fire department tasked me with setting up a tracker using excel. Any help would be appreciated. I currently have condition formatting set up so that within a timeframe it will show yellow for if its due within 2 weeks and shows red after it passes 3 weeks. I want...

I am trying to conditionally format a cell based on other conditional formatting in a range of cells. Ex. I would like cell E3 to be: Red if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Red IF NOT THEN Yellow if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Yellow IF NOT THEN Green if any...

Hi! Is there a way to do a conditional formatting so that if X cell has ANY value in it? As in, just NOT blank? Cell G8 I want to turn red if cell L3 has anything at all in it. It's so simple, and I'm sure that there's something like, "L3="#value"" or some trick to do that. I just have...

Hello everyone, Been stuck on this for a while and thought you guys might be able to help out. I am writing a program and a snippet from fails to run. Basically i have a column of values and blanks that vary from -10 to +10. I wrote this code to flag values of interest. The selection for...

Hello, I am trying to figure out how I can have conditional formatting depending on text in one cell relating to value in another cell, but for several different items... for example DATA <tbody> Item Value 1 Value 2 Apples 15 43 Oranges 18 24 Bananas 7 34 Mango 3 8...

I'm embarrassed to even ask this question. Anyone with half a brain should be able to do this, but not me. I've very rarely used conditional formatting, except for something VERY, VERY simple in Excel97. I'm now using Excel2007. I want to highlight Col-L value with bold red font whenever it...

I would like every cell in column A formatted either Red or Green based on the following logic: If the corresponding (same row) cell in column B is a 0 then a positive number in Column A should be highlighted/filled Red. If column B is 0 and Column A is negative number then Column A cell...

On which tab and how do I set the condition formatting so the linked cell will report the results of less than "RED" or greater than "GREEN" on a Summary Report in the same workbook in Excel. I've tried both pages and it won't work.

Hi, I am working on a macro which copies data from multiple sheets, creates a new sheet and pastes it in the new sheet sequentially and then sorts the data based on a column called "Region". But, every time this macro is run the conditional formatting rules change their ranges and multiply...

Hello there, I am trying to do something that thought would be simple but does not seem that easy :-) I have a cell (A1) with a list of currency value (USD,EUR,...). I would like another cell (A2) to have the currency format related to that currency automatically applied based on the value of...

Hi everyone, I have a spreadsheet in which I have created a line graph from containing 9 columns and a few hundred rows so far of data. Example below - (please note managers can have multiple scores on any one day and different managers can be audited on the same date) Date; Area; Event...