Conditional Formatting

[JJ Nieuwenhuis]

HI

I require assistance concerning conditional formatting.
As per my spreadsheet attached, I require Column E to be highlighted if the date is 10 working days less than C2 which has the =today() formula in it but also only if there is no date in column F.

Thanks for the support

Regards.

[Olly]

Use CF formula:

Please Login or Register  to view this content.

Apply to range E7:E19, and format to suit.

[Olly]

If you need to count back WORKDAYS:

Please Login or Register  to view this content.

[Pete_UK]

Highlight the cells from E7 downwards, then click on Conditional Formatting | New Rule | Use a Formula ... , then in the dialogue box enter this formula:

=AND(E7<$C$2-10,F7="")

Click on the Format button, then the Fill tab and choose your colour, then OK your way out - Excel will automatically adjust those cell references to suit the highlighted cells.

Hope this helps.

Pete

[JJ Nieuwenhuis]

OllyXLS / Pete_UK

Thank you for your support, I appreciate it.

Formula works.

Thank again!!!

[Pete_UK]

Glad to hear it - thanks for feeding back.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete