Conditonal Format based on two different criteria

C

Chad_Oglesbay

Hi all. In column A I have a list of a bunch of different test names. In
column D we have times associate with each test. I would like to make a
conditional format that will check column A for a specific test name and then
check to see if the time in column D meets a certain requirement. This is
what I have tried but can't seem to get it to work.

=AND($A$4="CBC",D$4$>.0416)

Anyone got any ideas?
 
L

Luke M

It should work...make sure your time really is greater than 0.416, and not
something like 0.41599999999
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Help with Sumproduct searching cell contents 2
Comparing two columns with conditional formatting 4
Sum a range based on a column 2
condionally formatting based on another cells formatting? 2
Pivot Table/Conditional Formatting Guru Help 2
Calc to show difference in numbers in two columns 3

Top