I want the font color to automatically change if the number entered is below 1,000,000. Is that possible? If so, how?
2006-09-22 04:59:40 · 6 answers · asked by Liesl W 2 in Computers & Internet ➔ Software
You can set this up using the conditional format command via the drop down menus. Either select a single cell or column/row/worksheet and follow the prompts.
2006-09-22 05:03:24 · answer #1 · answered by Anonymous · 1⤊ 0⤋
There's no formula for that, but you can use Conditional Formatting.
Select the cells you want to change color, then select the Format menu, then conditional formatting. The rest is pretty intuitive.
2006-09-22 05:09:41 · answer #2 · answered by pharaoh_of_atlantis 2 · 0⤊ 0⤋
So my answer makes it 4 on 4 for "Conditional Formatting".
We have a winner!
You will find it under the Format menu. It works for a single cell or a group of cells.
2006-09-22 05:08:48 · answer #3 · answered by Rustom T 3 · 0⤊ 0⤋
Highlight the cell
Menu > Format > Conditional Format
If (cell value) is less than 1,000,000
Then click on the format Burton to change its attributes
2006-09-22 05:06:51 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Yes, it is called conditional formating.
Highlight cell
click Format, choose conditional formating
Change default Between to less than
click format, choose paterns and pick a color
Thats all there is to it.
2006-09-22 05:05:35 · answer #5 · answered by Dennis K 4 · 1⤊ 0⤋
Go to help; look under conditional formatting.
Hope this helps.
Paul
2006-09-22 05:04:24 · answer #6 · answered by Paul M 2 · 0⤊ 0⤋