Office 2007 Beta up for grabs.

[mr_fishbulb]

The conditional formatting in Excel seems to be a bit stuffed.

For example if a cell contains the word NO I want to highlight it in red, so I set up a conditional formatting rule to do this, but when I change the value to anything other than NO, it is still in red. Works fine in 2003.

 

[FarFarAway]

Weird. Haven't tried Excel yet

 

[Phnom_Penh]

The conditional formatting in Excel seems to be a bit stuffed.

For example if a cell contains the word NO I want to highlight it in red, so I set up a conditional formatting rule to do this, but when I change the value to anything other than NO, it is still in red. Works fine in 2003.

Works fine here .

 

[FragTek]

I've been working on an intoxication level calculator in Excel and everything is working just fine for me here.

 

[Dav0s]

ive used IF statements, INDEX and MATCH statements with no worries.

absolute cell references working fine aswell, ill try some CF later

 

[mr_fishbulb]

Works fine here .

Strange. I've set up a conditional format that formats only cells with Specific Text containing NO that turns the text red. It works when I first enter NO into the cell - the text turns red, but when I change the NO to anything else it stays red, rather than going back to black.

It works fine when I set-up conditional formatting for a value (say I want it to turn red when I enter 10 in the cell). That turns red when I enter 10 and changes back to black when I enter a different value.

It's just the Specific Text part I can't get to work.

What does your rule look like?

 

[Phnom_Penh]

Strange. I've set up a conditional format that formats only cells with Specific Text containing NO that turns the text red. It works when I first enter NO into the cell - the text turns red, but when I change the NO to anything else it stays red, rather than going back to black.

What does your rule look like?

meh, you said highlight before . Tbh, create a counter rule that says if cell contains value not including no, set to black.

 

[mr_fishbulb]

meh, you said highlight before .

Whoops :$

I'll give the counter-rule a go

Edit - The counter rule works. Bit of extra work compared to 2003 though.