| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing font colour depending on cell value
Hello, I am hoping someone out there can help me out, I want to change font
colour in columns but the data is in two formats, but both meaning the same i.e. 10% & 1-10 i would like to be able to turn all data in a column to red if say under 7% & also turn the same columns data to blue if above say 25%. This needs to work in a few different columns and with different criteria for some columns. Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing font colour depending on cell value
Highlight the column then click Format, Conditional Formatting. If you need
more info than this, let me know. The wizard is reasonably self-explanatory. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "RunRonnyRun" wrote: Hello, I am hoping someone out there can help me out, I want to change font colour in columns but the data is in two formats, but both meaning the same i.e. 10% & 1-10 i would like to be able to turn all data in a column to red if say under 7% & also turn the same columns data to blue if above say 25%. This needs to work in a few different columns and with different criteria for some columns. Any help is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop the font from changing colour automatically? | Excel Discussion (Misc queries) | |||
| Changing Colour of Bar depending on Value | Charts and Charting in Excel | |||
| Changing font colour in some cells | New Users to Excel | |||
| changing the colour of cells depending on the content. | Excel Discussion (Misc queries) | |||
| Changing cell colour depending on another cells value... | Excel Discussion (Misc queries) | |||
Hybrid Mode
