Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
This is probably very simple to do but I can't seem to figure it out. I would
like to fill a cell with a color if the value of another cell has a particular name in it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Assume cell with name in it is A1, cell you want colored is A2.
Select A2, go to Format-Conditional Format. First box change to "Formula is" for the formula, input: =A1="ParticularName" Choose whatever format you want. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "mykcap" wrote: This is probably very simple to do but I can't seem to figure it out. I would like to fill a cell with a color if the value of another cell has a particular name in it. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Hi,
1. Highlight all the cells on the rows you want formatted, suppose cell A1. With B1 containing the text that triggers the formatting. 2. Choose Home, Conditional Formatting, New Rule 3. Choose Use a formula to determine which cell to format 4. In the Format values where this formula is true enter the following formula: =B1="Yeasterday" 5. Click the Format button and choose a format. 6. Click OK twice "mykcap" wrote: This is probably very simple to do but I can't seem to figure it out. I would like to fill a cell with a color if the value of another cell has a particular name in it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |