condit format formula

Hello, I am new to this so please excuse my ignroance... this is my first post... I just have a question I want to create a macro that cuts data from a certain range in one sheet and then pastes that data into another sheet if one condition is met. So I have attached this spreadsheet as an...

Hi there, I am just after a little help to finish my attempt of automating a conditional format that I use often. I use it to check to different columns of data to see if they are identical or not. This is my code below. Sub Conditional_Formatting_MatchData() Dim rng1, rng1a, rng2, rng2a As...

Hi, I have 2 date columns in my worksheet, E and F. If 14 days have passed from the date entered in column E and there is no value in column F I would like the cells in column F to turn red. I tried to use the below formula but it doesn't seem to be working. Also when I click and drag the...

Hello, I have a chart in sheet 4 (E2:AJ18) that is a list of tote numbers. In sheet 1 I am "adding a tote" to the system and want it to find the tote that was entered in sheet 1 (A:2) and highlight it Red in the chart. and then in sheet 14, after any cell in column J is populated with...

I have a worksheet where I am trying to apply conditional formatting. I want to apply the equation =($C$6/'Q1 2016'$C$6)>$H$39 I am trying to apply this to my entire worksheet but it will only work for the cell C6. The entire range I am using is from C6 to AB10. How do I have this code which...

Below is a simple spreadsheet Columns A-I, Rows 1-4. I seek a formula if at all possible to fit the following criteria to be placed in Column i, under Conditional Format, using Excel 2003: GREEN - Total registrations Outstanding <0.5 x Avg regn Closure rate AND regn Outstanding 30-90 days <10%...