conditional formatting formula

[wayneeustace]

Hi - very simple one but can't seem to solve it, sorry
I need A1 to highlight red if A2 is <>7. I can't seem to get the formula right in the conditional format. Thanks.

 

[AlanY]

this

Book1
	A	B
1
2	6
3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$2<>7	text	NO

 

[wayneeustace]

this

Book1
	A	B
1
2	6
3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=$A$2<>7	text	NO

Thank you, Alan - yes that works. I'm sure I tried that but I think Excel may have been adding brackets or apostrophes. Anyway it's working now - appreciate the help.

 

[AlanY]

you're welcome
thanks for the feedback

 

[wayneeustace]

you're welcome
thanks for the feedback

Sorry, forgot also ask - how do I then copy that across to other cells ? The $ absolute reference prevents a straight copy doesn't it ?

 

[Fluff]

Which cells do you want the CF to work on?

 

[wayneeustace]

I need it to work on A1 through to Z1, dependent on the values of A2 through to Z2.
Thanks.

 

[Fluff]

In that case select A1:Z1 & then create a rule using

=A2<>7