Conditional Formating. Troubles

[cav~firez22]

I am having a little difficulty with this little task, and im hopeing one of you can help me out here.

If any of the values in cells (C6 to AG6) are less than AJ6, then colour cell yelow
and the same for c7 to ag7 /aj7


any help please???

 

[cav~firez22]

anyone?
please?

 

[Smitty]

You can highlight the range C6:AG7-->Conditional Formatting-->Formula Is-->=C6<$AJ6-->Apply Format.

HTH,

Smitty

 

[cav~firez22]

Thank you, that worked on one, but not the next one i tried?

odd.

could there be another way, maybe a VBA code to write to the sheet?

i still cant figure out why its not working on the second sheet. same layout as the first....

 

[Smitty]

You didn't mention anything about a second sheet in your original post.

Are you trying to reference one sheet from another, or just duplicate sheet1's CF on another?

Smitty

 

[cav~firez22]

No worries. apparently i havent had enough coffee this morning.

I thank you greatly for your help.

the method worked on both sheets.