Conditional formatting for a column range

[willow1985]

Hello,

I have never been good with conditional formatting. I thought what I was trying to do was simple but it does not seem to be working.

Here is a screen shot of what I am trying to do:

Summary:

If column E has any blank cells, change the font to red
If Column F contains the text "N" change the font to blue
If Column F contains the text "Y" change the font to green
And I want it to apply to columns A:L

Please let me know what I am missing???

Thank you

Carla

 

[DanteAmor]

In these cases you have to define the range of rows, for example:

 

[willow1985]

Thank you very much. Have not worked much with conditional formatting

 

[DanteAmor]

You always learn something new, is to be trying until it works ?

I'm glad to help you. Thanks for the feedback.

 

[willow1985]

Definitely always learning! And the way my work has been challenging me daily I think this forum will be seeing a lot of me

Thanks again

 

[DanteAmor]

With pleasure, have a nice weekend