I am truly a beginner in Excel and need all the help I can get!

Okay so I have a table that is $A$2:$N$333 and I would like column A to show a data bar to reflect the data that each row has completed. Example: Row 3 has data in every column up to G now I'd like Cell A3 to show a 50% data bar in that cell to show that only 50% of the data needed for that row has been entered. Is that possible and how would I go about doing so?

(this is the reply I revieved from tech support)

If you add another column for the data bar, you can do it with conditional formatting.

If you insert a column before column A and inserted this formula:

=COUNTA(B5:O5)/14

And then use conditional formatting in the cells in column A

(open) conditional formatting

Use: format all cells based on their values

Choose data bar from drop down check box to show data bar only

(in type) choose number from drop down

Enter 0 on minimum and 1 on max

Use solid fill and no border

and hit okay

I COULDN'T COPY AND PASTE THE IMAGE SO I DESCRIBED IT AS BEST AS POSSIBLE

(This is my reply )

So after I've entered the formula into each cell down column A do I high light all of column A and then select the conditional formatting with Data bar?

So I did Just that I copied the formula into each cell in column a and then I highlighted the column and did the conditional formatting using Data bars and I got nothing. In the picture it says edit formatting rule. I made a new rule with all of column A highlighted was I supposed to go through the manage rules window instead of make a new and also in the picture it says minimum (Type) Number 0 and max Number 1 was I supposed to put that in as well?

Thanks for all your help I'm sorry I am so new at this excel stuff

AND THEN I RECEIVED THIS REPLY

Yes, you need to have it look exactly like the image I posted for it to work, so you'll need the types to be numbers and values to be 0 and 1.

OKAY SO THIS ONLY ANSWERED ONE OF MY QUESTIONS AND IT STILL ISN'T WORKING CAN YOU HELP ME? PLEASE

THANKS FOR ALL YOUR HELP VINTA