Countif

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.
 
D

Douglas J. Steele

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.
 
Top