Conditional Formatting fill problem

I find it odd that you would call the windows functionality a bug when it does exactly what it implies...no color means don't apply a color.  If I want white I can select white.  In the Mac version it offers the same option but "no color" means white.  And you think the latter is what Microsoft intended?  OK, I think you're nuts. I can't in any universe think that the design intent was to force the user of conditional formatting to change the color.  I can elect to not change the font and I can elect to not change the border, but i cannot elect to NOT change the fill color.

Thanks for the code, that verifies that MS intends for the user to NOT change the fill color and that the dialogue box implementation is a bug in the Mac version.  100% positive.

Oh, and by the way, the line that says: "=IF($E$3=1,TRUE,FALSE)"

can be written much simpler as: "=$E$3 = 1"

The background color of a cell on a new, blank worksheet is “no fill.” If you change that setting by applying a color fill, then that setting is now the color that was chosen. To restore the state to no fill you would choose “No Fill.” 

That is entirely different from “don’t change the fill color state” which is what the Windows version does and is what you want to have on the Mac. The windows dialog box is inconsistent with the command to set the cell to “No Fill." If you choose “No Fill” then the cell state should be “No Fill” just as if you choose “yellow” the cell state should be “yellow.” The Windows version does not let you remove the fill even when you tell it to do so.

Let's go back to basics. 

I need the ability to conditionally change the font and/or border of a cell without changing the fill property.  If it's yellow, I want it to stay yellow.  I can do that in the windows versionbut I cannot in the Mac version.  If you want to call the windows version a bug, knock yourself out; whether it's a bug or a lack of functionality I don't care, but I cannot do what I need to do in the Mac version that I can in the Windows version.

We are just going to have to agree to disagree.

By the way, note that in the Windows version there is  "clear" button that removes all selections and allows no change to the fill properties of the cell.  It also exists on the font and border tabs

That same button exists on the Mac version, but only the ones on the font or border tabs work (i.e. no changes to font or borders).  The one on the Fill tab results in changing the color.  There is no way you can tell me that the windows version is wrong when 5/6 tabs all work the same and the one that doesn't is on the Mac version.

Doing what XL Vato suggests only works if you want the underlying cells with no fill (condition met or not).  There are times I choose to baseline color-filled cells, and this versions of Excel will not allow me to use conditional formatting to just change the font or border.  Because this post is old I went back and tried it again.  I will outline exactly what I did to demonstrate the issue for those insisting that this is NOT a bug but rather intentional behavior (and that the Windows version way of doing this is the real bug):

1. Fill a sheet with yellow with blue font and put distinctly borders around each cell
2. Put random numbers in the first few rows of column A.
3. Select Column A and create a new conditional format (CF) that selects any cell whose number is greater than <you pick>.
4. Select custom formatting and change the font, the style/color of the borders, and a fill color. Save and verify all three are happening.
5. Now edit the CF again and select the "clear" option on all three (font, border, and fill).  The font and borders will revert back to the baseline settings but the baseline yellow fill will not come back.

What I'm demonstrating is that the "clear" options allow you to set a CF to not affect for border and fonts but will not allow you the same luxury for fill. In all version of Excel on Windows for the last decade the "clear" option on the fill tab does allow a CF to not touch the fill colors.

I cannot state this more clearly...this is a bug.  This cannot be intentional behavior unless the coder was an idiot.

That's odd.  granted the semantics in the dialogue box of "No Color" should in fact mean to leave it alone but as it was pointed out it formats the box white.  There is a button in the lower right corner that says clear.  That will remove any fill settings and leave the cell with it's original fill color (at least it does for me an multiple computers).

By the way, this is the feature that's broken on the Mac...the clear doesn't do anything in this dialog (but from memory it does for the Fonts, Borders, and Numbers tabs).

Thanks, but as I stated in my original post, that replaces the original fill color with white.