Hi all
in my work sheet i have ##### in some col which i dont wont,so help me with the formulae.
I want the row to be highlight in the active cell,and when i move to the next cell that row should get highlight.
Work sheet attached.
Thanks
Hi all
in my work sheet i have ##### in some col which i dont wont,so help me with the formulae.
I want the row to be highlight in the active cell,and when i move to the next cell that row should get highlight.
Work sheet attached.
Thanks
Last edited by iqss; 02-16-2018 at 09:51 AM. Reason: WRONGE TITLE
Please Login or Register to view this content.
Last edited by daboho; 02-16-2018 at 06:34 AM.
OK - you have tried. Thanks.
Post #2 has been reinstated now.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi all moderator
i have change the title ,i hope the prob is over now and i may get some help.
Thanks
See post #3.
The cells show ###### because the column width is not large enough to show your result. Your result is actually #VALUE!. The reason you are getting value errors is that the formula is trying to do arithmetic on a cell with the value of the null string (red cells in column H). There are two ways to fix this.
1) Formula in column H returns 0 instead of "" if COUNT <> 2.
=IF(COUNT(A13:B13)=2,MAX(1,INT(B13+TIME(21,59,0)-A13)),0)
2) Modify formula in N:
Formula:Please Login or Register to view this content.
Column W refers to N so fixing this in column N will also fix W.
As for highlighting active row, that requires a macro as shown in post #2.
HI 6StringJazzer
yes it works
high lighting is not working,with the post #2
the full row of active cell to be high lighted.till the time corser is in that row.
thanks.
Last edited by iqss; 02-19-2018 at 05:26 AM.
IQSS - please do NOT use capitals. This is considered as shouting online, but more importantly, it is very hard to read. Please edit post #7 and change it to sentence text. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks