Conditional formatting Stuck in Range

Dear All respected forum ppl.

I m stuck

Plz correct this formula which i am not figure-out the solution in conditional formatting for highlighting the date

Please Login or Register  to view this content.

i want to merge C6,C7,C8 in rage

Plz help

Regards

Originally Posted by JohnTopley

Please post a file showing expected results.

=AND(TEXT($C$6,"mmmm")<>$X$7, TEXT($C$7,"mmmm")<>$X$7,TEXT($C$8,"mmmm")<>$X$7)

Thanks alot for reply and help but unfortunately it dont solve the problem

i have attach the file for your consideration plz check
Coditional Formating 01.xlsx

what is required is Cant find the solution

I m trying to solve the C6, C7 & C8 highlighted month & year through the Cell X7 selection
i.e: if i chage X7 "the month from "Sept" to any other month it will highlight "C6, C7 & C8 " to RED showing that Wrong month in "X7" OR Wrong Date in "C6, C7 & C8"

but when i change the date in C6 from "1-Oct-15" to any other month all the cell from " the C6, C7 & C8 " get RED which is not Correct and cant solve it

Any help plz appreciated

Regards

Make separate rules for C6 , C7 and C8

i.e repeat C6 CF for cells C7 and C8 with "applies to" single cell i.e C7 only, C8 only

Just confirm
If the value in x7 is September and the values in c6 = sept, and the value in c7 and c8 are any other month; then you want the c7 and c8 to highlight?
If this is the case the you just need to remove the $ from in front of the "6", so $c$6 becomes $c6.
Peter

=TEXT($C6,"mmmm")<>$X$7)

Originally Posted by JohnTopley

Make separate rules for C6 , C7 and C8

i.e repeat C6 CF for cells C7 and C8 with "applies to" single cell i.e C7 only, C8 only

thanks for reply.

this is the main big issue "Make separate rules for C6 , C7 and C8" which i dont want to make it separate bcz when i drag down across the date from C6 to C8 the Conditional formatting settings get messed up and the formula in "Conditional formatting" dos'nt work correctly

that's why i need it in to "C6:C8" in range so Conditional formatting setting work in all options i.e Copy past/ drag and drop or drag down across

Hope there is a solution for this issue

Regards

Originally Posted by peterjuhnke

Just confirm
If the value in x7 is September and the values in c6 = sept, and the value in c7 and c8 are any other month; then you want the c7 and c8 to highlight?
If this is the case the you just need to remove the $ from in front of the "6", so $c$6 becomes $c6.
Peter

=TEXT($C6,"mmmm")<>$X$7)

Genius So great you solve it.. i was trying to solve it from may hrs and i cant figured it out this $ sign

many many thanks for your kind help

Reputation as added and thread is marked as solved Cheers

High Appreciated

High Regards

Your welcome