Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for colors
Hi,
In my range A8:A20, I have formulas which return Dollars and cents. All the numbers are displayed in black. How can I incorporate in my formula (it's just an If statement), a way to change the color of the lowest number in the range to Red. Thankyou. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for colors
Select your range A8:A20 click FormatConditional format In the first box: formula is in the 2nd box: =A8=SMALL($A$8:$A$20,1) Click the format click on the Color box and click on re ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula for colors
Thankyou for your prompt reply.
Works perfectly and I've learned something to boot. Kind regards -----Original Message----- Select your range A8:A20 click FormatConditional format In the first box: formula is in the 2nd box: =A8=SMALL($A$8:$A$20,1) Click the format click on the Color box and click on red ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula using colors | Excel Worksheet Functions | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) |