Hi,
this one has been wrecking my head for a while now, and i cannot seem to find any useful information on the internet about it. hope someone here can help.
Basically, i have a column in Sheet 1 that is to be formatted with red green or yellow when the corresponding cell in Sheet 2 is formatted.
the cell in sheet 2 is formatted manually and no text values or numbers are entered.
is this impossible? because i cant seem to find a solution.
Thanks in Advance.
Conor
So is it as simple as - if cell A1 on sheet2 is red, cell A1 on sheet1 should be red? Or is there some other condition to be noted?
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yeah almost,
for example. in Column A there are 'parts'. We need column B in sheet1 to go red if the same part in sheet2 column C goes red. does this make sense? ive attached a sheet to better describe hopefully.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks