Changing color in one cell based on an input from a another

[Markat pratt]

hi
i am using an xls file that a friend created , when i add a time value for a job completed on one page of the workbook ,vba goes to another page in the workbook and turns a corresponding block from red to green to show that the item is now completed. my problem is i have added three more pieces of equipment to the list (using columns) when i add time to those new boxes they do not update the box on the other page .
i am not sure if i can paste an example or attach this file to this type of forum .
i think is some type of c.formatting but i am not sure how she did it,i have played with this for a few hours -clicking on cells and playing with the avaialbe functions but i can't figure it out.
i would gladly email the file to someone who could help if this post is not clear .
thanks for the help

 

[shippey121]

you can send it me if you like

c_shippey_at_gcfg_._com

not sure if ill be able to sort it but ill have a look

 

[Joe4]

shippey,

Not a good idea to post your email address like that. SPAMBOTS scour internet forums like this looking for email addresses to send SPAM to.

It is recommended that you disguise it, like:
ajones_NO_SPAM_@xyz.com

or send it in a PM.

 

[dave3009]

Hi There

Sound very much like your friend is using hidden columns to get data from one page to another then applying C.Format based on these values

Look along the top of the column headers for some missing letters. Let say for example sheet1 has your input page, sheet2 has your formatted page. sheet1 Column A is where you put your date in, sheet2 A is where it relates to and IV is your hidden column

in sheet2 IV1 youd have something like

=IF('Sheet1'!A1>0, 1, "")

Copied down as far as it needs.

You'd then apply this format to sheet2 A1

Formula is: =IV1=1 then set your format

Then when you enter a date in sheet1 A1 - sheet2 IV1 will become value 1 and the C.format would change

This could be adapted for any number of columns assuming you don't need more than 3 formats


HTH

Dave

 

[shippey121]

thanks for the tip JM14 ill bear it in mind if i post it again,