Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Desperate NEED!!!!
I have a form that we use at work... I have some problem barges that come in time to time that we have to make changes to the job orders on. I put all the barges on this excel sheet. What I need is maybe an if statement or conditional foremat that will either shade the cell in or something. Just some way of letting me know that it is one of the problem jobs. The thing is I have used conditional formatting but you can only do three, I have at least 10 or so barges. I really don't know how to use the "IF" statement. Can anyone help me with this? -- huntr357 ------------------------------------------------------------------------ huntr357's Profile: http://www.msusenet.com/member.php?userid=630 View this thread: http://www.msusenet.com/t-1869437357 |
#2
|
|||
|
|||
Hi!
So, what do want to do? It's not really clear! Do you want to highlight the barge number that's entered in the form if it's a problem barge? If so, list the problem barges somewhere on your sheet, say J1:J11. Assume you enter the barge number on your "form" in cell A1. Select cell A1 Conditional Formatting Formula is: =OR(A1=$J$1:$J$11) Select the desired styles OK out Biff "huntr357" wrote in message ... I have a form that we use at work... I have some problem barges that come in time to time that we have to make changes to the job orders on. I put all the barges on this excel sheet. What I need is maybe an if statement or conditional foremat that will either shade the cell in or something. Just some way of letting me know that it is one of the problem jobs. The thing is I have used conditional formatting but you can only do three, I have at least 10 or so barges. I really don't know how to use the "IF" statement. Can anyone help me with this? -- huntr357 ------------------------------------------------------------------------ huntr357's Profile: http://www.msusenet.com/member.php?userid=630 View this thread: http://www.msusenet.com/t-1869437357 |
#3
|
|||
|
|||
From your explanation you could just change the background color of the cells
without the conditional format. But asuming there is information in the row containing barge information that indicates a problem condition you could use conditional formating to highlight the row. As an example, if in column A you had a 1 if this was a problem barge and no entry if it wasn't. You could then select the entire range of barge information and set in conditional formating in the "Formula is" dropdown =$a1 = 1 and all rows with a 1 in column A would receive the format you set. Lance "huntr357" wrote: I have a form that we use at work... I have some problem barges that come in time to time that we have to make changes to the job orders on. I put all the barges on this excel sheet. What I need is maybe an if statement or conditional foremat that will either shade the cell in or something. Just some way of letting me know that it is one of the problem jobs. The thing is I have used conditional formatting but you can only do three, I have at least 10 or so barges. I really don't know how to use the "IF" statement. Can anyone help me with this? -- huntr357 ------------------------------------------------------------------------ huntr357's Profile: http://www.msusenet.com/member.php?userid=630 View this thread: http://www.msusenet.com/t-1869437357 |
#4
|
|||
|
|||
Hi huntr357
IF statements can not change the formatting of the cell. How do you know, other than by the desired formatting, if there this is a problem job? ... is there anything that can be used to distinguish which ones are and aren't problem jobs (maybe a "note" in column D or something?), if so, i'm betting we can come up with a way to make conditional formatting work for this situation. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "huntr357" wrote in message ... I have a form that we use at work... I have some problem barges that come in time to time that we have to make changes to the job orders on. I put all the barges on this excel sheet. What I need is maybe an if statement or conditional foremat that will either shade the cell in or something. Just some way of letting me know that it is one of the problem jobs. The thing is I have used conditional formatting but you can only do three, I have at least 10 or so barges. I really don't know how to use the "IF" statement. Can anyone help me with this? -- huntr357 ------------------------------------------------------------------------ huntr357's Profile: http://www.msusenet.com/member.php?userid=630 View this thread: http://www.msusenet.com/t-1869437357 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Desperate I know I asked before | Excel Discussion (Misc queries) | |||
Desperate I know I asked before | Excel Discussion (Misc queries) |