Conditional Formatting

[viper]

I just tried seaching the database and didn't see this but I'm having trouble entering the formula for conditional formatting.

I've tried this and it didn't work.


=If(activecell.interior.colorindex = "Blue")


I just need to check that if the cell color is blue then set the font color to white.

Thanks,

[Bob Phillips]

I just tried seaching the database and didn't see this but I'm having trouble entering the formula for conditional formatting.

I've tried this and it didn't work.


=If(activecell.interior.colorindex = "Blue")


I just need to check that if the cell color is blue then set the font color to white.

Thanks,

The index in Colorindex should give you a clue ... it is a number not a text string, referring to its position within Excel's 56 colour palette.

Also, activecll.interior.colorindex is a VBA construct, so you cannot use that ina worksheet function.

And finally, conditional formatting doesn't set the cell interior colour, it is a presentation attribute, soemwhat akin to number frmats.