Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,comp.apps.spreadsheets
|
|||
|
|||
Any method to set cell background color conditionally ?
Hi,
I'm compiling a long list of percentage data stored in a single column of excel worksheet (say it in column A). I want to label different ranges of percentages by different colors e.g. 0-20% by yellow, 20-40% by orange, 41% above by red, etc. How could I do that with excel function ? |
#2
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,comp.apps.spreadsheets
|
|||
|
|||
Any method to set cell background color conditionally ?
"come_mon_come_mon!" wrote...
I'm compiling a long list of percentage data stored in a single column of excel worksheet (say it in column A). I want to label different ranges of percentages by different colors e.g. 0-20% by yellow, 20-40% by orange, 41% above by red, etc. How could I do that with excel function ? You can't do it directly with functions, but you could use Conditional Formatting (menu command: Format Conditional Formatting...). However, conditional formatting is limited to 3 conditions plus the default cell formatting, so only 4 different states. |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Any method to set cell background color conditionally ?
Use in Format Menu - Conditional format. change "Cells Is" box to "Formula
Is" box Or you can use procedure at the following microsoft webpage http://office.microsoft.com/en-us/ex...CL100570551033 "come_mon_come_mon!" wrote: Hi, I'm compiling a long list of percentage data stored in a single column of excel worksheet (say it in column A). I want to label different ranges of percentages by different colors e.g. 0-20% by yellow, 20-40% by orange, 41% above by red, etc. How could I do that with excel function ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add background color to cell | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
Conditionally setting background color of a cell | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Background changes conditionally | Excel Discussion (Misc queries) |