Formula to change font color

You can't use an in-cell formula to do this however you could use either

a) Custom Format

or

b) Conditional Format

to do this...

the latter certainly offers more flexibility but is "super-volatile" so is best used in moderation...

If you intend to only adjust the font colour (not the interior background) and have fixed boundaries then you can use a basic Custom Format... using your example:

[red][<70]#.00;[COLOR 10]#.00

If neither of the above conditions hold true then you should use Conditional Formatting, see: http://www.contextures.com/xlCondFormat01.html

see: http://www.contextures.com/xlCondFormat02.html

Hmm, that seemed like the perfect solution, again, for what I wanted. But for some reason I can't get it to work.

Essentially, what I want my spreadsheet to do (now) is if C2 is less than 70 then B2 font will be red, and if C2 is greater than or equal to 70 than B2s font will be green. This will continue down the whole row of B and C

I've mimicked their formula but it's just not working for some reason.
This is what I'm trying under conditional formatting for the cell;

First I select Cell B2, and under the format

Formula is =$C2<=70 (select red font)
and the other is
Formula is =$C2>=70 (select green font)

What am I doing wrong?

What am I doing wrong?

You're confusing Excel. If the actual value is exactly 70, Excel can't determine which CF applies because your formula states if the value is <= 70 then (red font), but if >= 70 then (Green font). Since a value of 70 meets both conditions, Excel can't apply the CF.

Use:
=$C2<70
=$C2>=70

Originally Posted by Palmetto

You're confusing Excel. If the actual value is exactly 70, Excel can't determine which CF applies because your formula states if the value is <= 70 then (red font), but if >= 70 then (Green font). Since a value of 70 meets both conditions, Excel can't apply the CF.

Use:
=$C2<70
=$C2>=70

Yeah, I'm an idiot, I just typed it wrong, I actually had it just like you wrote, and it still isnt working.

See attached example.

Originally Posted by logan_fernandes

Yeah, I'm an idiot, I just typed it wrong, I actually had it just like you wrote, and it still isnt working.

When you go back and look at the CF do you see quotes around the formulas? If yes, remove them..

If no, attach a workbook showing problem.

See amended example in the workbook in my previous post.

Excel Conditional Formatting Based on another cell

Nevermind!! This worked!! Palmettos amended example was exactly what I needed! Thanks a lot guys!

You rock!

Alright, thanks so much for your help everyone, I greatly appreciate it. We can close this thread now

To mark the thread as solved, go to YOUR first post at the top and click on Thread Tools, then Go Advanced, choose the [Solved] prefix.

Don't forget to leave feedback and add to the reputation of those who contributed a helpful response. See my signature for how to go about it.