# Excel Question - Color of Font

**URL:** <https://boards.straightdope.com/t/excel-question-color-of-font/171519>\
**Category:** Factual Questions\
**Created:** [April 27, 2003, 6:02pm UTC](https://boards.straightdope.com/t/excel-question-color-of-font/171519 "2003-04-27T18:02:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![xicanorex](https://avatars.discourse-cdn.com/v4/letter/x/a88e57/32.png) [@xicanorex](https://boards.straightdope.com/u/xicanorex)\
**Post date:** [April 27, 2003, 6:02pm UTC](https://boards.straightdope.com/t/excel-question-color-of-font/171519/1 "2003-04-27T18:02:18Z")

</div>

Is really simple. Really.

Set up:  
I have a spread sheet. At the end of each colum $X amount. I want the $X.00\>0 to be red to let me know that I still owe money So that at the bottom of that cell, the word “owe” is in red. If cell=$0.00, then at the bottom cell “paid in full” is in blue. That’s it.

I went to the library and got out 3, yes 3!, books on Excel. All state that yes it can be done, but none gives an example of a formula. I asked Excel and it leads me nowhwere.

So, I implore to the TS Dopers, can I have just a simple formula in a cell that just turn “owe” into red (based on any amount above zero) and “paid in full” into blue (based on if zero yes paid in full)?

THANX

XicanoreX

---

<div class="post-metadata">

**Author:** ![sailor](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@sailor](https://boards.straightdope.com/u/sailor)\
**Post date:** [April 27, 2003, 6:06pm UTC](https://boards.straightdope.com/t/excel-question-color-of-font/171519/2 "2003-04-27T18:06:04Z")

</div>

Go to Format - Conditional Formatting