Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel IF statements and conditional

Comment:

What is the formula for an IF statement to hilight any value or text, if that value appears more than one time in any given column? Using conditional format in excel

Name: DerbyDad03
Date: November 2, 2007 at 10:49:10 Pacific

Reply:

Have you searched the Excel help files for Conditional Formatting and looked at: "Locate duplicates by using conditional formatting." It's there in Excel 2003...can't speak to other versions.

0

Install Visio 2003

Microsoft Works 7

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ten. Basically, I need a formula that says IF the ...

Summary: Could I please obtain some help creating an Excel IF statement, considering the following parameters: - There is a date in cell A1 - The statement will appear in A2 - If the date in A1 is more than 30...

Summary: I'm am setting up a spreadsheet to track fuel consumption and hour of heavy equipment. I have conditional formatting set to change the color of a cell when a peice of equipment is set for it's 250 ser...