conditional formatting a cell value

This is a discussion on conditional formatting a cell value within the Excel Questions forums, part of the Question Forums category; hi I have looked on Excel help for this but can't seem to find an answer. I am trying to ...

1. conditional formatting a cell value

hi I have looked on Excel help for this but can't seem to find an answer. I am trying to conditonal format some cells. What I have is a symbol in say cell D9 and a number in D10. the symbol and number in both cells are generated by a formula.
What I need to say in my conditional formatting is "if D9 is "x,y,z etc" then make red, green etc... However, because the symbol is generated by a formula, I can't just put D9="x,y". I was thinking of maybe a value formula but not sure how to use it?
Hope this is clear?!

2. Re: conditional formatting a cell value

Hello,

But,

in D7 enter 1
in D8 enter 0
in D9 enter = D7+D8
in D10 I have the formula =IF(D9=1,"x",IF(D9=2,"y","z"))

on this cell I have conditional formatting

Cell Value is equal to "x" and format as required.

Do the same for Y and Z.

Is this any help or have I missed the point completely?

3. Re: conditional formatting a cell value

Thanks for this, but the cell that I want to conditional format already has the formula in, as does the one above it (D9 & D10), so I need the formula in the conditional formatting box. I'm finding it really difficult to explain!

Lets try: D9 has a choose formula to put a symbol in if it meets certain criteria.
D10 has another formula in relating to another work sheet to show numbers.

I have conditional formatted the symbols in D9 to show red, green or black depending on what they are (simple cell value = "x" so green).
I want to conditional format the numbers in D10 to be red, green or black depending on the symbol in D9, but because they are generated by a formula, I can't just put D9="x" so green.

Does this make sense?!!

4. Format | Conditional Formatting

{Cell Value Is} {Equal To} = "x,y"

5. Re: conditional formatting a cell value

Hi, that still does not work because the cell value is not the cell i'm conditonal formatting? Thats the formula that I have in D9 - on the symbols. I'm formatting in D10 but the cell value I want to use is in D9?

6. In D10

Format | Conditional Formatting

{Formula Is} =\$D\$9="x,y"

7. Re: conditional formatting a cell value

Thank you so much!!!!!!! O wise one

I did not think that would work so I never tried that, as I though you just used \$ to make the cell references stay put when dragging or pasting.

Many thanks again.

8. Re: conditional formatting a cell value

Sorry, I meant I never tried it before asking for help here, as obviously I have just tried it and it worked.....! Thanks

9. Re: conditional formatting a cell value

In F10, enter
{Formula is} =F9="x"
for the conditional formatting

10. Re: conditional formatting a cell value

Originally Posted by chariot
Thank you so much!!!!!!! O wise one

I did not think that would work so I never tried that, as I though you just used \$ to make the cell references stay put when dragging or pasting.

Many thanks again.
You're Welcome

Take Care

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•