# conditional format formula

1. ## conditional format formula

Hi,

I am aiming to highlight table row A17 to Q17 based on F17="Finished" and (L17="Finished" or L17 is empty "").

Any help appreciated

2. ## Re: conditional format formula

Select the cells A17 to Q17b and launch the CF dialog to create a new rule. Use this formula:

=AND(\$F17="Finished",OR(\$L17="Finished",\$L17=""))

3. ## Re: conditional format formula

Thanks, that works great. thanks. How can I amend to highlight based on F17="Started" and L17= is empty "" or F17="Finished" and L17= "Started" ?

4. ## Re: conditional format formula

Thus:

=OR(AND(\$F17="Finished",\$L17=""),AND(\$F17="Finished",\$L17="Started"))

5. ## Re: conditional format formula

Thank you very much

7. ## Re: conditional format formula

can this be simplified as the first 2 ranges are the same

=SUMIFS(G18:G134,P18:P134,A3,F18:F134,"Started")+SUMIFS(G18:G134,P18:P134,A3,F18:F134,"Expected")+SUMIFS(G18:G134,P18:P134,A3,L18:L134,"Started")

8. ## Re: conditional format formula

I suppose it depends if you think your formula is simpler!!! I'm not really sure it is. I think it would require more processing as it uses arrays.

There are currently 1 users browsing this thread. (0 members and 1 guests)