No Styles Group & Conditional If/Then Font Colors

**edgemont1** · 10-29-2012, 05:05 PM

Hi there:

I am a long time Mac user who now works at a job running Office 2010 on a PC. I have used Excel for ages but I am stumped on the PC as to how to just simply have the following conditional format:

If (this cell which contains a simple addition formula) is >0, then I want the font to be black.
If (this SAME cell which contains a simple addition formula) is <0, then I want the font to be red.

On a Mac this is a simple pulldown that allows you to add many conditions on one cell.

On this PC, firstly I have NO "Styles" Group on the Home tab. There is no "Styles" group anywhere to be found anywhere in this Excel. (Macs don't have "Styles" or "Groups")

So I went into the Options and added the Conditional Formatting function to the Quick Access Toolbar, and all it seems to allow me to do is fill the cell with color. I don't want to fill the cell with color, I want the font color to change. So I chose to Create a New Rule. However, this does not allow you to make more than one rule per cell.

I am SO frustrated.

Can someone please just tell me how to accomplish this simple task?

Thanks!!!!

**JosephP** · 10-29-2012, 05:09 PM

you can create as many rules as you like using the create new rule option-what problem are you having when you try?

**edgemont1** · 10-29-2012, 05:19 PM

Firstly, thank you for helping me Joseph.

When you choose New Formatting Rule (Cuz I see no other choice), you get predetermined choices none of which apply to what I need to do, so I choose the last one "Use a formula to determine which cells to format"

Is there another choice to accoplish what I want?

As I described above, all I see is a choice to make ONE rule on one cell. On a Mac, you can keep adding rules onto the same cell like:

IF C:3>0 (then you click the font color format and pick your color - my case black);

Then there is a plus sign that let's you add another rule like:

IF C:3<0 (then you click the font color format again and make it red)

I can make it do ONE font color on a cell, but I don't know how on here to make it do the other font color ON THE SAME CELL. When I tried to add another rule on the same cell, it doesn't do it.

ARGH!

Any help you can give me to accomplish what I'm trying to do (its the simplest of math equations!) is greatly appreciated.

**FDibbins** · 10-29-2012, 05:19 PM

CF is on the Home tab, under Styles. once you are in there, select "new rule" (you can select as many here as you need). then select "use formula" and enter you're CF rule, and format as required

let me know if you still have a prblem?

edit: based on you'r last post...
new rule - use formula
IF C:3>0 format as needed

enter back to main CF screen

new rule - use formula
IF C:3<0 format as needed