Using multiple rules for one cell

**BAClawgirl** · 08-19-2015, 03:43 PM

Hi!

I am trying to have one cell correspond to two tables within the same worksheet. It is a date, and the color of the first (and second, hopefully) row(s) of the tables change according to the date. The first table is all set with conditional formatting =C5<$X$5 then the cells <X5 will be highlighted. C5 being the row in the table and X5 being the date. How do I do it for the second table, which essentially needs to be X5-1 month? If it helps, the date is a formula so that it will be the first day of the month.

**FDibbins** · 08-19-2015, 03:48 PM

Hard to say without seeing what you have, but maybe take a look at the EDATE() function?

=EDATE(X5,-1)

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**BAClawgirl** · 08-19-2015, 04:09 PM

Sorry, really new to this. How do I upload the sample workbook? There does not appear to be an attach icon on the reply

**BAClawgirl** · 08-19-2015, 04:19 PM

Example.jpg

This is what my worksheet looks like

**FDibbins** · 08-19-2015, 05:01 PM

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**BAClawgirl** · 08-19-2015, 05:14 PM

Thank you so much for your help! I figured it out, it was easier than I thought it would be, it was simply =C29<$X$5-31

**FDibbins** · 08-19-2015, 05:22 PM

That will work find for 31-day months, but what about 30...or 28-day months? That's why I suggested EDATE()

Using multiple rules for one cell

LinkBack

Thread Tools

Rate This Thread

Display

Using multiple rules for one cell

Re: Using multiple rules for one cell

Re: Using multiple rules for one cell

Re: Using multiple rules for one cell

Re: Using multiple rules for one cell

Re: Using multiple rules for one cell

Re: Using multiple rules for one cell

Thread Information

Users Browsing this Thread

Similar Threads

Need help in how to add multiple rules in vba code for macro by double clicking a cell

Multiple IF, THEN rules

conditional formatting rules for a cell on sheet 1 based on rules from sheet 2

[SOLVED] Outlook 2010 - Creating Rules - Rules Constant

[SOLVED] multiple validation rules

Conditionally format every individual cell in a selected range with multiple rules

Multiple Rules for Worksheet_Change

Bookmarks

Bookmarks

Posting Permissions