Conditional Formatting for Budget Worksheet

[oboegal21]

Hello,

I am looking for help on creating a budget worksheet to do the following:

* Display pay period date range (as in columns A and C in the example provided)
* Highlight if the day (1st, 5th, 12th, etc) falls in that date range

I am wanting this so I can eventually calculate the total amounts in the highlighted fields for the end of the year.

Thank you for any help you may be able to provide.

[José Augusto]

Use this formula

Please Login or Register  to view this content.

See the file.
Please note that D1:E1 must be numbers.

[oboegal21]

That's perfect!! Thank you so much for your help!