Hi all,

I'm trying to apply some conditional formatting to a range of cells where, if the cell DOES NOT EQUAL the value "FALSE" and another cell contains the word "Red" (there's more colors, but that's academic) then formatting occurs.

In the conditional formatting box, I've entered the following formula:

=(AND(D3<>"FALSE",$DA3="Red"))

I thought the "<>" would indicate does not equal, or at least give the same results, but no joy.

Any ideas?

TIA,

SamuelT

I'm trying to apply some conditional formatting to a range of cells where, if the cell DOES NOT EQUAL the value "FALSE" and another cell contains the word "Red" (there's more colors, but that's academic) then formatting occurs.

In the conditional formatting box, I've entered the following formula:

=(AND(D3<>"FALSE",$DA3="Red"))

I thought the "<>" would indicate does not equal, or at least give the same results, but no joy.

Any ideas?

TIA,

SamuelT

- Conditional formatting involving formula that "DOES NOT EQUAL" something
- What is "DOES NOT EQUAL" language?
- Would conditional sum work for this? (does not equal zero)
- "Freeze" Conditional Formats - HELP!
- Delete rows based on a specific value in column A only if column B does not equal a different specific value
- Delete lines where cell does not equal criteria
- Saying does not equal in VB
- Conditional Formatting slows open
- VBA Autofilter using Cell Ref & Does not Equal to
- If B1 does not equal "Apples" then do
- Excel 2003 / Pivot Chart / Conditional Formatting / Macro
- IF (does not equal) Statement
- Can not select conditional formatting
- If does not equal - multiple items
- IF function does not equal
- IF does NOT equal formula ???
- SUMPRODUCT - How can I use does not equal in an array?
- "does not equal"
- Counting based on conditional format
- Does not equal
- Delete Rows if value in cell does not equal desired value ACROSS multiple sheets
- Does not equal operation
- Macro to delete entire rows where O2:O does not equal a date
- Use Conditional Formatting When Reference Cell Not Blank

Is there a way in conditional formatting to state where you fill in the formula "does not equal"?

I only want the cell to be included in the sum if it does not equal zero.

TIA!

I have a spreadsheet that develops part of a report based on a data sheet. The final report is formatted with conditional formatting. I need to copy a section of the report and paste it into a new spreadsheet while at the same time retaining the formatting. The conditional formats are however dependant on data that does not get copied to the new sheet.

Is there a way to "Paste special freeze formats" or another method that will achieve this.

The new spreadsheet does not need conditional formats but must retain the formatting form the original spreadsheet when it was copied.

[ This Message was edited by: robmac on 2002-09-18 02:20 ]

I need to build a macro, which will delete all rows with a specific value in column A, only if column B does not equal a different specific value. I can't seem to find any relevant posts. thank you very much.

-p

In column B I have alot of values (TF, GF, UF, HF, etc). I want a macro that will delete lines where cells in column B do not equal TF).

Thanks for any help!

Does anyone have any suggestions? I would like to include it before I send the file in. This specific tab has no formulas, and other tabs in the same workbook have conditional formatting (not anywhere near the scale though).

I am using autofilter in vba and can now set the criteria by the value in a set cell. However I want to use the Does not equal aspect () and Can't seem to get the right syntax to make it work.

Can anyone help me with where to place the (), I have scoured the web and come up with nothing.

Code is

.AutoFilter Field:=8, Criteria1:=Sheets("Cover").Range("C7"), Operator:=xlAnd

Many thanks

I have worksheet Food which has 2 columns.

In cell A1 I have a data list pulldown menu with the following values:

Lettuce

Spinach

Apple

Cucumber

In cell B1 I would like to have the following:

IF A1 does not equal "Apples" THEN write the value of 2 * 2.

Nothing needs to happen if A1 does equal "Apples".

Do I need to do this in VB Script? Or can it be expressed as a function?

Thanks for your help.

(This "first data" moves around when adjusting the pivot table.)

Also, how do you take the value of a cell on the worksheet, and place it into a macro...for instance cell A20 on the sheet has the value of F12, I want F12 to be a selected range in a macro.

Thanks

I've got a function which I need a little help on please:

I'm currently using:

but need to use something along the lines of:

How do I code the part in square brakets, ie a value does not equal?

What I'm finding currently is that with a singular $G19>94.5% function, the cells with an NA text value are being copied across as a 100% value rather than #NA.

Thanks

Jan

conditional formatting, nor can I paste the conditional format of that cell

to other cells.

any ideas?

--

Gary Beard

I was wondering if any one can help, I am looking to apply a formula which chages if does not equal an item

So as an example

If cell does not contain either A or B or C change to X, so would leave all my cells with A or B or C unaffected and all other rows would now display as X

Hopefully making sense!

Cheers

Remo

eg I have one column, that is perforning a SUMIF providing that a certain cell is equal to a particular constant.

=IF([cell]=[value],SUMIF([range],[criteria],[sum_range]))

In the next column I want to do it the other way round so that:

=IF([cell] DOESNOT=[value],SUMIF([range],[criteria],[sum_range]))

Is it just a simple symbol??

Thanks

I want it to be everything other than "red" for example.

i have a spreadsheet which is used to keep the training records for the company it counts no of staff and their skill levels for different parts of the job, when a person moves to a different branch the skill required changes and they have a set period of time to aquire the new skill.

when the time is up the colour of the old skill is changed to a red font by a conditional format based on the date.this is then counted by a calculation so the team know how many people are to be targeted for extra training.

the problem i have is the calculation will not count conditionally formated cells, so whenever i update the sheet i have to go to each cell with red text and change the font colour manually to red, this sounds really silly and is impossible to explain to anyone who does not understand conditional formatting. i e the people who will end up using the database

what im looking for is a way to count conditionally formatted cells based on the condition being met i.e. they are showing as red font.

can it be done and how?

or am i wasting my time looking for an answer to something excel wont do ?

Thanks

I am trying to delete rows from selected sheets in a workbook if the value in a column does not equal 'Paper'

Below is what I have and I have attached a workbook. I can get it to delete the rows I want on the active worksheet but it doesn't work on the other sheets when I select multiple sheets. In this case I want to be able to select the tabs for Sheet1, Sheet2, and Sheet3 and have it delete all rows except for the header and rows that have 'Paper' in column A. Please help.

Sub DeleteRowSheets() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim CurrentSheet As Object, Rng As Range, ix As Long Set Rng = Intersect(Range("A2:A6"), ActiveSheet.UsedRange) For Each CurrentSheet In ActiveWindow.SelectedSheets For ix = Rng.Count To 1 Step -1 If Trim(Replace(Rng.Item(ix).Text, Chr(160), Chr(32))) <> "Paper" Then Rng.Item(ix).EntireRow.Delete End If Next Next CurrentSheet End Sub

I tried the <> but that returns true or false.

what I wanted to do was, if cell A1="Manager", then leave blank, otherwise return the cell value.

Is this possible?

Thanks

Can someone suggest to me a good efficient macro that would delete rows where O2:O does not equal a date. So if I have this information in the column O as below:

HEADER Complete Complete Date in past 03/05/2011 Complete Complete No info Quarrantined Complete Complete Complete Complete Complete 18/04/2011 18/04/2011 Complete Complete CompleteThen after the macro run it would only leave me header row and the rows with dates like this.

HEADER 03/05/2011 18/04/2011 18/04/2011Any ideas?

Cheers

Rain