I am trying to set up a quick review of a wokbook

[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.

[PaulM100]

Not sure it I understand your query. Assuming that you want to change only the colour of the cell, based on those 3 conditions, then you will need conditional formatting and set the rule for D17 and J17 like: =AND(D3<>"", D9="") and set the fill to red. Same with J17

[elsmith9035768]

Solved on another forum:
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

[elsmith9035768]

Thanks for your help

[Logit]

.
elsmith9035768

For future reference, you can help us to help you by providing a link to the other forum posts ... in your first post on this forum.

As all Excel related forums have this requirement, you should post a link to this thread in the other forum posts as well.


Thanks !