Conditional Formatting

[mykcap]

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.

 

[Luke M]

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.

 

[Shane Devenshire]

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