Conditional Formatting

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello From Steved

I have been trying out =DAY(L35)+24, L35=Dec formated
as "mmm" I put it in Conditional Format it will work. I
ran =DAY(L35)+24 on several years using Conditional
Format to change colour and it works.

Now that I am happy this works I would like to put it in
my December Calendar as A conditional format please.
cell L35 = Dec ("Month") formated ("mmm")

Any Ideas please
 
Sorry, no idea what you are talking about. At least one of us is having a
bad night!
 
Yes I am the one that is having a bad day

lets see in Feburary the 6th it is a holiday, So I would
like a formula to be put in Conditional Formatting that
will change the Cell to a diferent color to reflect it is
a holiday as an example
=DATE(YEAR($D$14),6,8)-WEEKDAY(DATE(YEAR($D$14),6,6))
will find the first Monday in Jun. but this time I Want a
formula to find the 6th Feb cell D3 is Feb formated "mmm"

Hoping this is a better explanation.
 
Back
Top