When I put a value can I get a message in excel

Asked By 20 points N/A Posted on -
qa-featured

Hello excel expert, I will be working in MS excel row no A1 to A100. My Question is when I put the same value in row A1 to A100 then how can I get a message, example when I put value in row A1= 250 if have any row (A1 to A100) value 250 then it will show RED COLOR or show a message like "Double posting"

 

Thanks

Tareq

SHARE
Answered By 0 points N/A #177579

When I put a value can I get a message in excel

qa-featured

Hey Tarequtt,

Using the COUNTIF function to check a range of cells, like in your case, A1 to A100, you can get a message informing you that the number you are putting in has already been assigned. To get this message, you have to name your data cells since data validation cannot use the table column name directly. Then use that range name in a COUNTIF formula, and any time there is a double posting, you will get a message (as in the image below). I hope this information helps.

Related Questions