Conditional Formatting Formula

[jo.stanley]

This is probably not to difficult but I cant get it to work.

If A1 contains the word test and cell A2 is greater than 25 then highlight entire row

 

[AlanY]

try

=AND(ISNUMBER(SEARCH("test",$A1)),$B1>25)

applied to the whole sheet

 

[jo.stanley]

Unfortunately I cant get that to work, unless I am doing something wrong to apply to the whole sheet

 

[AlanY]

have you used =$1:$1048576 in "applies to"?

have a look of this

https://drive.google.com/file/d/0B1h-Y2fdTl08dk1VVWltcU0wN3c/view?usp=sharing