Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row when certain data is entered
Hi,
I have a worksheet that various people work on and I would like for the row to highlight yellow when someone enters Paid Off and red when Missing. I also would like for the row to highlight red when Other ineligible data is entered into the row. Please help. thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row when certain data is entered
You could use conditional formatting to do this (available on the
Format menu). What do you class as "Other ineligible data"? Pete On Jan 28, 5:10*pm, Maggie wrote: Hi, I have a worksheet that various people work on and I would like for the row to highlight yellow when someone enters Paid Off and red when Missing. *I also would like for the row to highlight red when Other ineligible data is entered into the row. *Please help. thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row when certain data is entered
On Jan 28, 12:25*pm, Pete_UK wrote:
You could use conditional formatting to do this (available on the Format menu). What do you class as "Other ineligible data"? Pete On Jan 28, 5:10*pm, Maggie wrote: Hi, I have a worksheet that various people work on and I would like for the row to highlight yellow when someone enters Paid Off and red when Missing. *I also would like for the row to highlight red when Other ineligible data is entered into the row. *Please help. thanks- Hide quoted text - - Show quoted text - I actually type out Other Ineligible Data. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row when certain data is entered
Okay, well suppose you type those entries into column D, but you want
the row from column A to column M highlighted as you described. I'm assuming you have a header row, so that your data starts in row 2. Starting with A2, then, highlight cells across to M2 and then down for as far as you think you need. Click on Format | Conditional Formatting, and in the pop-up you should select Formula Is rather than Cell Value Is in the first box. Enter this formula in the second box: =$D2="Paid Off" Click on the Format button, then on the Patterns tab (for background colour) and click on yellow then OK. Then click Add to set up the other condition, and choose Formula Is again, and enter this formula: =OR($D2="Other Ineligible Date",$D2="") Click on the Format button again and this time choose red, then click OK twice to exit the dialogue boxes. If the cells in column D are empty then the rows should all appear red, but you can test the settings out by putting other values in those cells - type Paid Off and the row should turn to yellow, but if you put, say, xyz in the row is not coloured. Obviously, you need to change the references to suit your data. Hope this helps. Pete On Jan 28, 5:45*pm, Maggie wrote: On Jan 28, 12:25*pm, Pete_UK wrote: You could use conditional formatting to do this (available on the Format menu). What do you class as "Other ineligible data"? Pete On Jan 28, 5:10*pm, Maggie wrote: Hi, I have a worksheet that various people work on and I would like for the row to highlight yellow when someone enters Paid Off and red when Missing. *I also would like for the row to highlight red when Other ineligible data is entered into the row. *Please help. thanks- Hide quoted text - - Show quoted text - I actually type out Other Ineligible Data.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row when certain data is entered
I've just read your other thread, and realise that you enter the word
"Missing" - I thought you meant that it was empty. So, you will need this as your second condition formula: =$D2="Other Ineligible Date" and after you have put that in click on Add and use this for the third condition: =$D2="Missing" and set this for a pink background. Hope this helps. Pete On Jan 28, 7:23*pm, Pete_UK wrote: Okay, well suppose you type those entries into column D, but you want the row from column A to column M highlighted as you described. I'm assuming you have a header row, so that your data starts in row 2. Starting with A2, then, highlight cells across to M2 and then down for as far as you think you need. Click on Format | Conditional Formatting, and in the pop-up you should select Formula Is rather than Cell Value Is in the first box. Enter this formula in the second box: =$D2="Paid Off" Click on the Format button, then on the Patterns tab (for background colour) and click on yellow then OK. Then click Add to set up the other condition, and choose Formula Is again, and enter this formula: =OR($D2="Other Ineligible Date",$D2="") Click on the Format button again and this time choose red, then click OK twice to exit the dialogue boxes. If the cells in column D are empty then the rows should all appear red, but you can test the settings out by putting other values in those cells - type Paid Off and the row should turn to yellow, but if you put, say, xyz in the row is not coloured. Obviously, you need to change the references to suit your data. Hope this helps. Pete On Jan 28, 5:45*pm, Maggie wrote: On Jan 28, 12:25*pm, Pete_UK wrote: You could use conditional formatting to do this (available on the Format menu). What do you class as "Other ineligible data"? Pete On Jan 28, 5:10*pm, Maggie wrote: Hi, I have a worksheet that various people work on and I would like for the row to highlight yellow when someone enters Paid Off and red when Missing. *I also would like for the row to highlight red when Other ineligible data is entered into the row. *Please help. thanks- Hide quoted text - - Show quoted text - I actually type out Other Ineligible Data.- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
CAN I HIGHLIGHT A CELL TO STAY HIGHLIGHTED UNTIL DATA IS ENTERED | Excel Discussion (Misc queries) | |||
Highlight if Data entered appears in another workbook | Excel Worksheet Functions | |||
?-Change data series range as data is entered? | Charts and Charting in Excel | |||
Why won't my newly entered data sort with old data ? | Excel Discussion (Misc queries) |