conditonal formating

Hi to all! My question regards a vba code. How to conditional Formatting Shapes in a sheet? I have a product list on sheet1 Many shapes on sheet 2, linked to every cell in sheet1 that contains that product name. I need to color the background of every shape, if they contains the word for...

This is part of a larger macro to update several workbooks. Some Worksheet names have numbers only and some letters only. I cannot figure out how to loop through each worksheet named with numbers and update the conditional formatting below. Sub test2() Dim sht As Worksheet 'ADD...

I'm attempting to create a spreadsheet that imports .txt files from FedEx Ship Managerand then conditionally formats the zip code cells based on the ship zone they are in. Right now I have far too many conditional formatting scenarios and it causes excel to crash so I would like to simplify...

I am unsure how to make this formula work for me. The example ia: I have a list of values in A1 that range from 1-25 that can be selected. In B1 i need a formula that will make B1 a certain value based off what number is in A1 Example: A1. B1 1. 1 2. 2...

Hi All Need some help with a conditional formatting problem I want to format a row of cells based on the value of the cell beneath it, eg. highlight in green if value in the cell is greater than the cell beneath it, and highlight in red if the value is less than the cell beneath it. So, cell...

Hi, In conditional formatting I'm trying to create a formula to say highlight if the difference between two cells is great than 5000 both ways. So, I've started =IF(A1="Standard", and this is the part where I need to say the current cell is a difference of 5000 compared to the previous cell...

Hi I have used conditional formatting in my sheet to highlight error in formats(I have used red color), now i want to count the # of reds. The conditional formatting fill is not like the normal fill hence I am facing an issue to count it. Can someone help me with this? Thanks, Prashant

Hi All, I hava a cash flow as Date INCOME 02/02/2010 usd 353 05/04/2010 usd 1050 05/08/2010 usd 500 04/09/2010 usd 100 I want to make a formula which will sum up the INCOME data of whch are before the date in the cell A3 As I change the A^the formula will calculate...