Conditional formatting - Can it satisfy two conditions?

I've set up a very simple conditional format on a numeric column, with numbers less than zero colored red, and numbers greater than zero colored green. Now, if I also want to make the column bold when an additional condition is true (1st of the month, derived from a formula).

=DAY($C130)=1

But it seems that only one of the conditions can be met, and only one conditional format applied. Or am I doing something wrong?

Is it necessary to use four conditions for something like this? Red/non-bold, red/bold, green/non-bold, green/bold? That would quickly become onerous if you wanted to add additional formatting like borders, italics, etc.

Originally Posted by AliGW

Just create an additional CF rule for the same range of cells.

That's what I've done, but it doesn't appear to have an effect if either of the first two conditions is met. And why I'm asking the question.

A very simple test:

Condition 1: Cell Value is greater then 0 -> color green
Condition 2: Cell Value is between 2 and 5 -> bold

Enter 3, you get only green, no bold.

Should have mentioned that I'm using Excel 2003. I don't see a 'stop if true' option.

Yeah, I found this:

https://support.office.com/en-us/art...5-8e8126076249

So looks like I'm SOL.