Conditional Formatting

[Shanyce02]

I am working with a table that requires me to create a new column and lookup data in another worksheet. Once I have completed the vlookup function it yields a letter. There are different types of styles (A, B, C, D) and I just want the rows that contains D to be formatted with orange. Is there a way I can still use conditional formatting when the cells i reference contain a formula and not manually entered? Hope this makes sense.

[Tony Valko]

What is the specific range that you want to format and what cell would contain D?

[Shanyce02]

The data is in a table in column O and there are multiple cells that contain the value D because I used a vlookup to find the styles that matched the order no. in my table. (So all the cells in column O have a formula which gives me the different styles {a,b,c,d})

[Tony Valko]

Let's assume the full range of interest is A2:O10.

Select the *entire* range A2:O10 starting from cell A2.
Cell A2 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=$O2="D"

Click the Format button
Select the desired style(s)
OK out

[Shanyce02]

No good. I'm starting to think because the cell I am referencing already contains a formula, its not picking up the D but the vlookup function instead. thanks anyway.

[Tony Valko]

No, whether it's a formula or manually entered wouldn't matter.

How about posting a SMALL sample file so we can see how your data is structured.