condional formatting

Hello, I need help regarding Excel formulas or Macros. It's kinda complicated so I will explain it. I'll post the Excel Template tomorrow as an attachment since my collegue who creates the Excel is not available by now. This Template has fictional employees. On the excel you can see 3...

I have a spreadsheet with 72 rows and about 10,000 columns. I have applied conditional formatting to highlight all the cells which have a value of less than 150. Is there a way of now deleting all the columns where ALL the cells are highlighted/less than 150? At the moment I have the cells...

Is there any way for the display formatting to be changed automatically dependent on whether ISO code I write? <tbody> ALL Lek AFN ؋ ARS $ AWG ƒ AUD $ AZN ₼ BSD $ BBD $ BYR p. BZD BZ$ BMD $ BOB $b BAM KM BWP P BGN лв BRL R$ BND $ KHR ៛ CAD $ KYD $ CLP $...

Hi all Can someone help me with a piece of conditional format via VBA. It is doing my head in. Excel somehow changes the input value from my input box - it is simply different to what I select when prompted. I want to set a conditional format. First I prompt user to select which cell to...

Hello - I am looking to use conditional formatting to highlight a cell red. I have 2 columns of text on separate sheets. If the text is found in column A on sheet 1, and its also found in column A on sheet 2 - highlight the sheet 1 text red I tried to use a formula to determine what cells to...

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

Hi again... I search the forum for an answer, but could not find one. I am simply trying to conditionally format cells to change fill color based on condition. When I select any cell, ones with numbers, formulas, or blank, I get a "No Cells Found" error message. Any thoughts?

I have input rangeA2:W50 & output range A53:W62 A2:A50 contains names W2:W50 contains numerical values or blank A53:A62 contains either of the ‘above’ names from A2:A50 In W53:W62, I am using INDEX & MATCH formula & get the analogous numerical values from W2:W50 W2:W50 contains CF example...

I'm using Excel10 & searched the KB & am unable to locate a simular situation... Column A Dept name Column B Actual fiscal YTD Hours Column C Estimated Hours for the year the goal is to create conditional formating on the actual values in the rows ofcolumn B if they meet the following...

I am trying to have conditional formatting color scale "Green - White - Red" be used when I have "Nominal" values selected in my pivot tables, but when "Rank" is selected I would like the conditional formatting color scale to be "Red - White - Green". Any ideas? Thank you!

I have a three cell merged conditional formatted section with the conditional formatted that has the color starting from one end and fading to white. The information in the cell is derived from a drop down menu. When the information changes only two of the cells changes and the last cell stays...

Numerical values are there in cells A24:N24 with EXCEPTION being there MAY BE some cells within the range A24:N24 which will contain either blank, alphabet(s) or alpha-numericals. (here D24 & H24). I have applied 6 CFs in each cell. Each CF is meant to generate 1 back ground color so that out...

I am using 48 columns to show the time slots of a day of 30 minutes each in cells A1:A48 as follows: A1 A2 A47 A48 0.30 1.00 23.30 24.00 Here the values are punched as numerical values. 1.00 means when current systems's time >0.30 & <=1.00 Similarly for 10.30 means when...

Cells U2:U500 contains numerical values along with Conditional Formatting done in all these cells. However, I want these CF to function ONLY if CS2=0. Ex: CS2=0 & U6=270.25. The CF should work in U6 (since CS2=0) CS2=1 & U6=270.25. The CF should NOT work in U6 (since CS2=1) How to accomplish?

Hi, I'm looking to set my sheet up so that when I2 contains any text(date in this case) the whole row highlights indicating the package has been sent. <tbody> </tbody> <tbody> Title 1 Title 2 Title 3 Title 4 Title 5 Title 6 Title 7 Title 8 Date Shipped Title 10 Text1 Text 2 Text3 Text4...

Hi, I am going through a large dataset of about 5000 records with 5 columns. Column D is an e-mail address field on which I have applied conditional formatting to highlight RED if the e-mail address contains "bt" anywhere in the address. What I am trying to do in Column F is to create an IF...

Hi, I hope someone can help me, this is driving me mad! I would like to make Cell A turn yellow if there are any blanks in the rest of the row. <TBODY> Name Date Name (GO YELLOW) Blank Name Date </TBODY> I hope this makes sense.. Thank you

hello all, i hope you could help me about conditional formatting border (top & bottom), for this below : <tbody> seq number (col.a) data (col.b) 1. george 2. mike 3. evan 4. john etc.. </tbody> how to add border with condition ; for number 1.---------put border...

This may be easy, but can you base the font color of a cell on another cell. I have a date with conditional formatting in E2 to turn the font red when the date is greater than a year. If E2 is RED, I would also like the font in C2 to turn red. Thanks in advance!

Hi Again. I am Conditional formatting a range of data which firstly falls below the target 20. This is to be highlighted in Yellow. Over this same data, I need to select the bottom 10% of data which excludes capturing 0's and #N/a's in red. Can anyone pretty please help me create a...