Conditional Formating. Troubles

cav~firez22

Well-known Member
Joined
Jun 21, 2006
Messages
543
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??? :)
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
You can highlight the range C6:AG7-->Conditional Formatting-->Formula Is-->=C6<$AJ6-->Apply Format.

HTH,

Smitty
 

cav~firez22

Well-known Member
Joined
Jun 21, 2006
Messages
543
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

Legend
Joined
May 15, 2003
Messages
29,536
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

Well-known Member
Joined
Jun 21, 2006
Messages
543
No worries. apparently i havent had enough coffee this morning.

I thank you greatly for your help.

the method worked on both sheets.
 

Watch MrExcel Video

Forum statistics

Threads
1,133,651
Messages
5,660,133
Members
418,551
Latest member
rambo17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top