Trouble with conditional formatting with formulas

[willow1985]

I always seem to have trouble with conditional formatting.
Here are the formatting rules I have created:

What I need is as follows:

=$F2:$F1000="Y" If column F has the text "Y" in it then the entire row (from A:N) should format the text to green
=AND($F2:$F1000="N",$F2:$F1000<>"") If column F has the text "N" AND the cell beside it in Column E is not blank it should format the text to blue

The only one that seems to work is the =$E2:$E1000="" then format the font Red.
The other 2 seem to only affect column E for some reason and only work some of the time. I just cant figure it out.

Any help would be appreciated, this is probably one of the functions of excel I dread working with....

Thank you

Carla

 

[willow1985]

Guess so, never thought to scroll down and then back up but it definitely had me puzzled ?
IT was in my pc this morning so perhaps that is how my automatic calculation got turned off but either way I added a VBA code to turn it on when the book is opened.

Thank you again! ?

 

[Fluff]

You're welcome & thanks for the feedback