conditonal formatting

  1. B

    Duplicate Value based off two columns

    I am trying to ensure that there is only one entry per day per area. Column A is the date of entry. The areas are a list "Anodizing", "Tumbling", "Cleaning", and "Passivation". Which are entered into Column B. I could pretty easily use a macro to do this, but if I can just use a conditional...
  2. L

    Remove Conditional Formatting via VBA in an existing macro, and protect new workbook created by macro

    Hi all, I have written 3 separate macros in a protected workbook which are running successfully, however I have 2 additional functions that I'm unable to get working. I have explained below what my macro does (in a nutshell) to give context to what I need to add in. 3 existing macros I am...
  3. M

    Macro to conditonally format cells >255 characters

    Hi all, Does anybody know how I would code a macro to conditionally format any cell that is >255 characters? The conditional format could be anything but I think changing the cell colour/font colour to red would be the best option. Here is a simple example of what I am after: <tbody> Apple...
  4. R

    Change the value of a cell based on another ... ?

    Hi all, Firstly, as always, apologies if this has been answered several times already! I have searched and tried various answers to no avail so now seeking professional help!?!?! :rofl: Basically, all I wan't to do is change the value of one cell based on what is entered into another. To be...
  5. J

    How to quantify Check-in/out data Per hour Per day

    Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...
  6. J

    How to quantify Check-in/out data Per hour Per day

    Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...
  7. S

    Excel 2010 conditional formatting on training record

    Hope you guys can help me. I have a training record for my team which list all of the training they have received. Most of the training is mandatory annual training. I'd like to be able to highlight the cells depending on when the training is due with a traffic light system. Red, overdue...
  8. mrxlsx

    Conditional Formatting match text in a string

    Good evening all, I have a column named Remarks. I want to apply conditional formatting for those cells which have the following text strings in that. How to do this ?? 1. Cancel 2. Cancelled 3. Invoice Cancelled 4. Invoice got Cancelled Thank you
  9. O

    Conditional Formatting to compare cell's value against anothers

    Longtime lurker who couldn't figure out/find a solution to my problem. For simplification, I have values in column A from A8:A16, but I only want to format A13:A16. I have the cooresponding values in which I want to compare A13:A16 in nonadjacent rows and columns I want to look at A13 and if...
  10. T

    Conditional Formatting of a third cell, based on the comparison of two different cells

    Hi, I'm trying to use conditional formatting to colour a cell, based on a comparison of two different cells. For example, A1 = 6 and B1 = 5, colour C1 green if A1 > B1 or red is A1 < B1. In the third cell I'm using the ABS formula to determine the difference between the two cells. I have...
  11. R

    Conditional Formatting question

    Hi everyone, Hope everyone is well. I have a quick question about conditional formatting. So I have a drop down list in cells A1:A4. The list contains the choices B, C and D. If choice B is made, I want the cell in the next column (and same row) "B2" to me conditionally formatted with a red...
  12. R

    Weird Conditional Formatting Results

    Hi I have a few weird situations with conditonal formatting in 2007. I want to change the formatting on a group of cells depending on the contents of a different cell. For exampe "=OR(C25>0,C26=TRUE)" applies to range: "$C$27:$C$31" However, 1. Sometimes it does not work until I either...
  13. K

    Conditional Formating - work around?

    I need to do some conditional formatting. I am using the formula selection. My formula contains more than 3 conditions. What is the work around in Excel 2010 not using VBA method.
  14. K

    Conditonal Formatting Chart

    Can someone help me plot a conditional cascade chart using the table below: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.4pt; WIDTH: 322.95pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 width=431...
  15. S

    Need Substitute for Conditional Formatting

    I am using excel 2007. I have a formula in cell J12 that produces a number from a list depending on what the value is in C8. But, I need that number to be negative (formatted red with parentheses) if cell J11=0 and L11<0. I know I can do the RED part through conditional formatting, but how do...

Some videos you may like

This Week's Hot Topics

Top