conditonal formating

  1. L

    Conditional Formatting Shapes that contains specific words

    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...
  2. R

    Conditional Format Loop

    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...
  3. W

    Conditional Formatting for Multiple "Between" values

    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...
  4. T

    Conditional formating/data tables

    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...
  5. D

    Conditional Formatting

    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...
  6. T

    Conditional formatting - difference between two cells

    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...
  7. P

    Count conditonally formatted cells

    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
  8. K

    Suming the income which are belong before to the certain day

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top