1. F

    Conditional Formatting Formula setup required

    I have a question regards to conditional formatting (highlighting) and what formula to use please. I have 4 rows A, B, C, D If A2 has any of these numbers - 1, 2, 3 and "D2" has any of apple, oranges, grapes, banana. I like the "ABCD" to highlight green. If A3 has any of these numbers - 4 ...
  2. W

    Conditional Formatting of multi cells

    I have some conditional formatting created thru - conditional format - highlight cells rule - equal to. They apply to $B:$B. I would like to change the results so if the cell in row b equals the condition the highlight would affect of not only that cell but the cells adjacent in columns a and c.
  3. J

    Conditional Formatting | Dragging to other Cells

    Hello! I have a very simple conditional format: =$I2>1/1/1900. Basically if I2 has a date greater than1/1/1900 then I want H2 to not have any fill and for the font to be regular. I have other conditional formatting in H2 to tell me if the date is expired. This works great BUT when I drag to...
  4. O

    Conditional Formatting on Font.Strikethrough

    I have a pair of conditional formatting rules which don't work as I expected. The first rule ("Stop if True" is unchecked) applies to $G$4:$G$7402 and sets the cell background color for dates older than today. This w<today() <today() <today() <today() orks fine. The second rule (same range)...
  5. F

    Conditional Formatting not working in excel 2010

    I am trying this formula =IF(OR($K7="2",$K7="3"),OR($<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size: small;">M7="LIL",$M7="BEG",$M7="GWY",$<wbr style="color: rgb(31, 73, 125); font-family: Arial, Helvetica, sans-serif; font-size...
  6. B

    Conditional formatting one cell to a column

    I have a workbook with several worksheets in it. I want to conditional format one column on one work sheet when: It matches the same exact number that could be in and any cell in a column in another worksheet Example: conditional format if – Review $G$11:$G$107 matches List $C$5:$C$329...
  7. K

    Conditional Format On A Date

    I'm trying to create a conditional format based on a reference date of every Friday. If the dates in the CHECK DATE area are greater than 7 days from the Reference Date, it'll highlight red. Below is the result I'm looking for, 04/11/19 is 8 days from Friday 04/19/19 so it's highlighted. I...
  8. W

    conditional date highlight

    Using the conditional format function how can I highlight any date equal or older than today()?
  9. P

    Conditional formatting base on another cell (if the cell 'contains' for direct match)

    Hello, I know i can do exact match formatting using the conditional formatting function, Is this possible? Data in A1 is selected from 10 options in a pick list (i.e 128 Leslie Road or 18 Taunton Street) I would like B1 to be highlighted (yellow is fine) if A1 contains either the word Road or...
  10. J

    Conditional Formatting Question

    I need some help with conditional formatting. I have three columns (C2:E31) with data in them. Column B also has data in it. When the value in column B is changed and the values of Columns C, D and E do not match what B is changed to, I want C, D and E to change color. Can someone please assist...
  11. M

    Conditional Formatting

    Please Help!!!:confused::rofl: I have a testdata sheet whih there is a min and max spec. i can setup the conditional formatting for less than, geater than, but here is where i am stuck.... Sometimes there is no spec but because i have a format for less/greater than it autoamatically...
  12. J

    Conditional Formatting

    Hello, I'm needing help wit the below: I need column F to highlight if column C equals 30. I've tried =IF(C:C,30) and it isn't working.
  13. B

    Conditional formatting rule

    Hello, is there anyone that would know how to setup a conditional formatting rule to bold any number that is in column A if it's appearing in column R?
  14. W

    Conditional Formatting within percentage range

    I'm trying to highlight cells within 5% of goal green and those that are outside the range to be highlighted red I tried to use conditional formatting formula and wrote it as the following, but it's not working out. =(ABS(A2-$A$1)/$A$1)<=0.05 Where is my error? Also, where should my anchors...
  15. J

    Conditional Formatting when all Fields = TRUE

    I am trying to change the border of a group of fields once all the fields contain the word TRUE. I was trying to set up a formula in Conditional Formatting but I do not know how.
  16. B

    conditional formatting

    Is it possible to setup a rule that can highlight a date in column H red if the date does not fall on a Monday or the 10th of each month?
  17. M

    Formula used to conditional format rule

    Hi there, I am looking to incorporate the below rule as a conditional format rule - use a formula to determine which cells to format. =IF(M2="","",IF(LEN(M2)>12,"Issue","OK")) Do I need to create two rules essentially to replicate this here? Or how do I amend this rule to "Format values...
  18. P

    Formula to find conditional formatting

    Hello All, I have a conditional formatting applied in column C to highlight the duplicate values. Now I need a IF formula in column A to say whether column C value is duplicate or unique. Can someone help me with the formula.
  19. T

    Conditional formatting dependent on a cell value

    I'd like to change the background color of a cell depending on whether another cell contains "TRUE" or "FALSE". I believe this can be done with the Cell function but I'm not sure how to make a formula for it. I have reference to, which is...
  20. T

    Conditional formatting nightmare

    Hi, Wondering if anyone can help or advise I have a sheet that has 3 columns with multiple conditional formatting rules to basically change the cell fill to red, orange or green depending on the date and what is in adjacent cells. The conditional formatting is working fine on my sheet but...

Some videos you may like

This Week's Hot Topics