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