Changing input fields to a different colour.

[AlanWade]

The never ending saga of my spreadsheet. So far it is terrific due to help from this forum. The next question, if I am not pushing my luck, is, is it possible to change the text colour automatically along all the fields to do with a weekend date to red. What I mean to say is if you look at what I have created, then it shows the first entry (A7) as a sonday so if I work that day can all the fields horizontally show red text?
thanks again
Alan

[AlanWade]

Sorry VBA Noob changed it now.

[NBVC]

Do you mean you want the row where the weekends occur to be in red font too?

If so, you can use the same Conditional Format as you already have to turn the Weekends red... but just add a $ in front of the A so that column A is frozen in all formulas..

[VBA Noob]

Thank you

Select the area and then use a formula like

=IF($A7<>"",WEEKDAY($A7,2)>5)

Example attached

VBA Noob

[AlanWade]

Once again, thankyou so much for your expertise.

Alan