Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hello
i have to worksheets. in worksheet1 i have in column A list of cell which contains descriptions . in 2 worksheet i have a data. 2 worksheet contains 3 columns. in columns C i have a list of data. FOR EACH cell from sheet2 and column C i want to check . if cell contains the same value as in any cell from sheet1 and column A, the value from sheet2 column C and actual cell should stay without changes. if cell from sheet2 contains data which isn't in sheet1 column A it should change the font of the active cell and background color for red ... so sheet1 is as a dictionary sheet2 contains data which should be checked. if cell from sheet 2 contains data which is include in sheet1 it should stay without changes if cell from sheet 2 constains data which isn't include in sheet1 it should change the font and change background for red. How can i do ?? please help me wolku SORRY for mistakes , I still learn english.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding a sum by matching two cells with the same identifier | Excel Discussion (Misc queries) | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding matching fields accross multiple worksheets | Excel Discussion (Misc queries) | |||
finding matching cells in worksheets | Excel Worksheet Functions |