hii all,
i have some problem about how to figure it conditional formatting top/bottom border skip blank data..
i'am very confused day to day......plain my head..
please, see it my sample data...
for your the help, thanks in advance and i appreciated
jhon mustofa
try this...
1. highlight the range you want to apply the conditional formatting to (=$A$3:$G$14)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND($E3<>"",$G3<>"") FORMAT border TOP LINE
Then repeat # & $ with this...
=COUNTA($A4:$G4)=0 FORMAT border bottom line
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
thank you, FDibbins..
It's really working..
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks