Quick Review of a Workbook

[elsmith9035768]

I am setting up a table for a quick review in a workbook. Data is fill in on many sheets throughout the wordbook and I want a quick reference as to see if I completed all the cells on all the pages. I need two formulas as some cells in the worksheets are blank and some cells contain a zero, based on the formula in the cell. Please see the attached file for an example and the description of the formula. Thanks.

 

[bosco_yip]

1] 1st Formula

Select D17:F17 >> Conditional Formatting >> New rule >> select "Use a formula…" >>

>> in the rule box enter: =ISERR(-SUBSTITUTE(D3," ",""))*(D9="")

>> click "Format" , choose background color in Red >> OK

2] 2nd Formula

Select J17:L17 >> Conditional Formatting >> New rule >> select "Use a formula…" >>

>> in the rule box enter: =ISERR(-SUBSTITUTE(J3," ",""))*ISNUMBER(FIND(0,J6))

>> click "Format" , choose background color in Red >> OK

Regards
Bosco

 

[Peter Bartholomew]

Instructions as per Bosco
= AND( line3=0, address<>{"", "0 0 0"} )
= AND( line5="", address<>{"", "0 0 0"} )

 

[bosco_yip]

Please Don't Cross-Posting

If you do cross-post, please put other website link in your post.

Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Regards
Bosco