YTL Excel # 126 part 3: Conditional Formatting w Formulas

Hello,
I am studying in my Excel 2007 book about structured references and conditional formatting. If I choose to use conditional formatting from ribbon button and enter a formula, I know I can use references such as =F7>B7 for example, but can I use [Sale Price]>[Asking Price] from lets say the SalesData table for example. It doesn't work when I use the words [Sales Price], etc, but the actual reference =F7>B7 work fine. Perhaps my synatx is off.

1) Are structured reference names from tables allowed in conditional formatting formulas at all?
2) If so, what is the general syntax.

Just curious. Still can do what I want to do but my book doesn't address this and can't find anywhere.

Hey i'm trying to figure this out in excel. I have two separate sheets of data and i would like to compare them with conditional formatting. The catch is one column is like "SCHOOL BOOKS" while the other column has values like "BOOKS". So i'd like it to conditionally match similarities that include parts of the data of one cell as opposed to perfect matches. how do i do this?

Sorry, I just can't get the hang of CF...

This time values will appear in H40:H42 if that value appears in J39:J44, I need the yellow highlighting as per my Jeanie please...

Sheet1

  H I J K L M N O P Q R 38       Games               39 1   6 6 Point Games   72 13.04% 68 12.32% 7 30.43% 40 3   4 4 Point Games   116 21.05% 119 21.56% 9 39.13% 41 1   3 3 Point Games   134 24.20% 124 22.46% 3 13.04% 42 0   2 2 Point Games   42 7.61% 54 9.78% 1 4.35% 43     1 1 Point Games   116 21.05% 119 21.56% 1 4.35% 44     0 0 Point Games   72 13.04% 68 12.32% 2 8.70%

Excel tables to the web >> Excel Jeanie HTML 4

Hello All,

I'm working in Excel 2007 and I need to set an entire row's fill color to Yellow if any cell in the row contains the string, "TBD". I need to do this even if the cell contains other characters, e.g., "The criteria for this rule are TBD."

Can this be done with Conditional Formatting? I've tried several formulas, including =COUNTIF(ROW,"*TBD*")>1, =SEARCH("TBD",Cell) and FIND("TBD",Cell), but none of them work. Any help will be appreciated!

I am using excel 2000

I want to apply conditional formatting to a range of cells if they contain (V) as part of the cell contents

The cells will generally look like this : 09.00-6 (V) or 9-5.30 (V)

I want to shade any cell if part of the contents of that cell is (V)

Thanks in advance for your help

Hi
I have a column that contains a goods in number 5 characters followed by a space then GII or GIP or a bin location ie A100, I want to use conditional formatting to highlight cells containing GII one colour and GIP another colour the remainder stay normal

Thanhs for your time

Steve

Hi,

on a dropdown list I'm using the 2 codes below:

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$D$10" Then
        Select Case Target.Value
        Case Is = 7: Call Macro13
        End Select
End Sub

where Macro13 is the folowing:


Code:

Sub Macro13()

' Macro13 Macro
'

    Range("AM33,AM34,AM36, AM38,AM41,AM45,AM48").Select
    Selection.Copy
    Range("A12").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Application.CutCopyMode = False
    Range("A1:A7").Select
End Sub

Can you please help me instead of selecting cells one by one to modify the macro to do the folowing:
Count in the range (AN5:AN100) if there is value "7" then select and copy matching cells in the range (AM5:AM100).

Appreciate your Help

I have a report titled, "Daily Sales Tracker", that has a separare tab for every day of the month. I have created an additional tab titled, "Reps" which pulls info from every daily tab to indicate if a rep worked or not. The info puuled is as follows:
1=Rep Worked
0=Rep Was Off
X or blank=Rep Did Not Report
We need to know when a rep has not worked for 3 consecutive days (0, X, or blank). I am attempting to use conditional formatting to fill those cells that meet that criteria, but have been having trouble doing do. I tried using the following formula:
=NOT(OR(C6=1,D6=1,E6=1))
and applying to to the following area:
=$C$6:$AB$57
but it's not working.

Does anyone have any suggestions on how to get this working?
Thanks!

I have a report titled, "Daily Sales Tracker", that has a separare tab for every day of the month. I have created an additional tab titled, "Reps" which pulls info from every daily tab to indicate if a rep worked or not. The info puuled is as follows:
1=Rep Worked
0=Rep Was Off
X or blank=Rep Did Not Report
We need to know when a rep has not worked for 3 consecutive days (0, X, or blank). I am attempting to use conditional formatting to fill those cells that meet that criteria, but have been having trouble doing do. I tried using the following formula:
=NOT(OR(C6=1,D6=1,E6=1))
and applying to to the following area:
=$C$6:$AB$57
but it's not working.

Does anyone have any suggestions on how to get this working?
Thanks!