and()

  1. Nuclearman83

    Linking Data from one Workbook to Another Workbook

    I have a program that I am require to use that outputs data horribly and makes it very hard to see the big picture for where everyone is for their certifications. I output everything into a CSV (only way I can) (Qualifications). I am trying to get the data to look more presentable so I can see...
  2. S

    Conditional Formatting Formula

    Hello (once again)! I am using some conditional formatting to highlight specific dates in a column based upon a comparison to the TODAY() function. The formula I am using in the conditional formating is: =AND($F2:$F10>TODAY(),$F2:$F10<$A$1) It is supposed to turn it yellow. It doesn't...
    • spydey
    • Thread
    • and() conditional conditional formatting excel 2016 formula issue formulas
    • Replies: 7
    • Forum: Excel Questions
  3. P

    Inconsistent COUNTIFS() function

    Hi, I've data in three columns as Cathode Make, Age, BT Sgl, 900, 970 Yunnan, 2100, 965 Sgl, 250, 978 Yunnan, 1678,969 Xhanxi, 299, 962 Xhanxi, 1890, 970 Sgl, 210, 971 Now I wish to count the no of readings in column 3(i.e. BT) Which are >970 with corresponding value in column 1(i.e...
  4. K

    Conditional fomatting based on AND(), INDEX() and MATCH() function?

    I have two spreadsheets with named tables. The first spreadsheet is named Components, and the table name is also Components :) Some of the headers are Art.no and PAH In my second spreadsheet I have another table linking some of the infomation from those components. Here I want to do some...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top