Will show error if you forgot to enter a data in one cell

[Elainefish]

I have a table where scores need to be entered in column C, D, E, but only one score should be entered in every one row.
Is it possible to make the cell red or any error message if (1) I entered 2 or 3 scores in each row (2) if I forgot to enter any score in one of the three cells

[tehneXus]

This will check the values "live" when you change them: error question.xls

[Elainefish]

This will check the values "live" when you change them: Attachment 234607

Hi,

This is exactly what I want
but can you please teach me how did you did this?
because the sample I attached is just a simple table and my real database consists of hundreds of columns and rows.

Thanks

[FDibbins]

Im not quite sure what post #2 did, but try this instead...

1. highlight the range you want to apply the conditional formatting to B2:D8 in your sample - adjust as needed
2. on the home tab, styles, select CF
1st, unless there is a reason why you are highlighting 5 red, delete that rule
3. select new rule, select use formula
4. enter =OR(COUNT($B2:$D2)=0,COUNT($B2:$D2)>1) format fill RED

[Elainefish]

Im not quite sure what post #2 did, but try this instead...

1. highlight the range you want to apply the conditional formatting to B2:D8 in your sample - adjust as needed
2. on the home tab, styles, select CF
1st, unless there is a reason why you are highlighting 5 red, delete that rule
3. select new rule, select use formula
4. enter =OR(COUNT($B2:$D2)=0,COUNT($B2:$D2)>1) format fill RED

Hi,
I am having problems with the formula
I attached the sheet I am working on
I tried =OR(COUNT($AP4:$AR4)=0,COUNT($AP4:$AR4)>1)
but seems it doesnt work

[tehneXus]

code explained (works with any amount of rows and columns):

Please Login or Register  to view this content.

if you experience a long runtime of the code you should remove it from the Worksheet_Change event and assign it to a button or some other event (e.g. BeforeSave).

Regards

[FDibbins]

I tested your file, its working fine except that it seems to only "finish" adding red if you enter something somewhere else. I dont understand why, but I will ask some of the other experts

[JosephP]

open the vb editor (alt+f11) and in the project explorer window (top left of the screen) select the Report sheet. if the properties window is not visible press f4. change the enableformatconditionscalculation property to true and save the file

[FDibbins]

Thanks JP

[JosephP]

my pleasure :-)