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

Markat pratt

New Member
Joined
Sep 14, 2006
Messages
1
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
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

shippey121

Well-known Member
Joined
Mar 21, 2006
Messages
1,001
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,844
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,377
Members
410,679
Latest member
rolandbianco
Top