Why does this not work

[cdsaroma]

When I enter this in 'Conditional Formatting' (cell M2) it doesn't work but if I enter it directly into the cell (M2) as a function it works (I get "No Pw")?

=IF(A2=2000,"No PW","")

I wanted to be able to change the cell color as well, that's why I was trying to use the Cond. Format.

thanks

 

[Jonmo1]

Conditional formatting needs a True or False statement..
That formula returns a text string of either "" or "No PW"

Try removing the IF, and just leave it as

=A2=2000

This returns either TRUE or FALSE, based on if A2=2000
When it's TRUE, the conditional formatting will be applied.
If it's FALSE, no formatting will be applied.

Hope that helps.

 

[cdsaroma]

Conditional formatting needs a True or False statement..
That formula returns a text string of either "" or "No PW"

Try removing the IF, and just leave it as

=A2=2000

This returns either TRUE or FALSE, based on if A2=2000
When it's TRUE, the conditional formatting will be applied.
If it's FALSE, no formatting will be applied.

Hope that helps.

So I can't return a text string from a Conditional Format?

thanks

 

[Jonmo1]

Conditional formatting doesn't "return" Anything...
It applies a specified format to cell(s) based on a Condition (true or false)

 

[cdsaroma]

Conditional formatting doesn't "return" Anything...
It applies a specified format to cell(s) based on a Condition (true or false)

Ok, thanks for your help.

What if I entered a (string of) functions into the cell and used the CF to give me the formatting depending on what is returned?

Could you help me put this into a string?
these are the (3) formulas:
=IF(A2<1994,"No PW","") =IF(A2>=1994,"Card","") =M2="lux"

thanks