Countif

  • Thread starter Thread starter Terry Boat
  • Start date Start date
T

Terry Boat

I have been given the answer to this, but have lost it - Sorry.

How do I check to see if a the number in A1 is in the range K10:P20, and if
so change the colour of A1 to Blue. I know it is something like
Countfi(K10:P20,A10)>0, and then I get lost.
 
Sorry, but this newsgroup is for questions about Access, the database
product that's part of Office Professional.

You'd be best off reposting your question to a newsgroup related to Excel.
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
Copy Exact Formula 1
Help with formula 2
Formula query? 6
Need formula: too complexe for me.. 11
Cell Content Cross Reference 1
Adding to a formula thru out a worksheet 2
Overtime Calculation 16

Back
Top