Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I color a cell if a certain criteria is met?
Is it possible to change the background color of a cell or text color if a
certain criteria is met? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I color a cell if a certain criteria is met?
Conditional formatting.
See http://www.contextures.com/xlCondFormat01.html -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nick" wrote in message ... Is it possible to change the background color of a cell or text color if a certain criteria is met? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I color a cell if a certain criteria is met?
Hi
You can use conditional formatting. Format-conditional formatting, and there you can make criterias and even formulas that will change the background and scriptcolour. -- Therese "Nick" skrev: Is it possible to change the background color of a cell or text color if a certain criteria is met? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I color a cell if a certain criteria is met?
yes
select the cell and go to format conditional formatting "Nick" wrote: Is it possible to change the background color of a cell or text color if a certain criteria is met? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I color a cell if a certain criteria is met?
Yes... Use conditional formatting in the format menu. you can set the
condition for which the colour of either the font or the background or both can change. "Nick" wrote: Is it possible to change the background color of a cell or text color if a certain criteria is met? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
Excel Cell Criteria Effect | Excel Worksheet Functions | |||
Place X in cell if criteria met` | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Using IF when more than one cell contains criteria | Excel Worksheet Functions |