Conditional Formatting question

Hi all, thanks for looking at my question.

I am trying to conditionally format a cell based on the number in the cell.

I'm sure its just a simple formula but I cannot work it out. It maybe I need two rules, I have tried but it seems to fail each time.

What I want is for the cell to turn red if the value is NOT equal to 45, and to remain unformatted if it is 45, or no input ("").

Row 1 has header notes, I would like this formatting from cell G2:G5000

Any help greatly appreciated.

Try:

(G2<>45)*(G2<>"")

Originally Posted by Phuocam

Try:

(G2<>45)*(G2<>"")

That works perfectly, thank you.
Can you tell me what the * is doing in this situation please?

(G2<>45) returns a true or false
(G2<>"")returns a true or false

true * true =true (1)
true*false=false (0)
false*true=false (0)
false * false=false (0)

Originally Posted by davsth

(G2<>45) returns a true or false
(G2<>"")returns a true or false

true * true =true (1)
true*false=false (0)
false*true=false (0)
false * false=false (0)

Thanks davsth, simple and effective, I've been using Excel for years and I love it when you find out new stuff.