MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
123Next
Return Post new threads
View: 745|Reply: 23

Conditional Formatting - format cells with zero value if ro

[Copy link]

15

Topics

80

Posts

197

Integral

Conqueror

Rank: 3Rank: 3

Integral
197
Post on 2-10-2017 05:07:54 | All posts |Read mode
If the total of the row is 0, then no formatting to apply. If the total of the row is greater than zero, format only cells in the row that are 0. Cells that have values must have no formatting. I have attached a sample file.
Thanks in advance.








  • TestFile.xlsx
    (11.8 KB, 0 views)
    Download








  • Reply

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 06:31:47 | All posts



    File attach use conditional formatting.








  • TestFile.xlsx
    (9.8 KB, 0 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-10-2017 07:39:24 | All posts



    Thanks for your reply




    Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-10-2017 08:52:30 | All posts



    Apologies, I posted before finishing sentence. If the total of the row is greater than zero, format only cells in the row that are 0 (your file has no formatting in cells with zero values). Cells that have values must have no formatting (your file has formatting in cells with values.
    Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-10-2017 07:33:22 | All posts



    File attach use conditional formatting.








  • TestFile.xlsx
    (9.8 KB, 8 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-11-2017 05:37:41 | All posts



    File attach use conditional formatting.








  • TestFile.xlsx
    (9.8 KB, 13 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 07:08:06 | All posts



    Apologies, I posted before finishing sentence. If the total of the row is greater than zero, format only cells in the row that are 0 (your file has no formatting in cells with zero values). Cells that have values must have no formatting (your file has formatting in cells with values.




    Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 07:29:40 | All posts



    Thanks, I have managed to solve the issue.








  • TestFile.xlsx
    (10.0 KB, 1 views)
    Download

  • Reply Support Opposition

    Props Report

    15

    Topics

    1390

    Posts

    2971

    Integral

    King

    Rank: 6Rank: 6

    Integral
    2971
    Post on 2-11-2017 06:44:04 | All posts



    File attach use conditional formatting.








  • TestFile.xlsx
    (9.8 KB, 15 views)
    Download















  • Reply Support Opposition

    Props Report

    15

    Topics

    80

    Posts

    197

    Integral

    Conqueror

    Rank: 3Rank: 3

    Integral
    197
     Author| Post on 2-11-2017 10:17:51 | All posts



    Thanks, I have managed to solve the issue.








  • TestFile.xlsx
    (10.0 KB, 5 views)
    Download

  • Reply Support Opposition

    Props Report

    123Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 9-21-2017 14:33 , Processed in 0.250896 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!