Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Conditional Formatting
I am trying to create conditional formating for my worksheet.
cell(row,column) If the value in For n= 1, end of active rows (cell(n,1) and cell(n,3) and cell(n,4)) = For i=n+1, end of active rows (cell(i,1) and cell(i,3) and cell(i,4) ) Then cell(n,5) = cell(i,5) or cell(i,5) = cell(n,5) If there is a missing for cell(n,5) or cell(i,5) then fill in the missing value. Or if cell(n,5) < cell(i,5) highlight both cells in red. From the example listed below in the third row and column 5 the value should be fill in with the value of Dallas. Listed below in the second and fourth row and column 5 both cells should highlighted in red. Example: Column1 Column3 Column4 Column5 1 10/1/07 34 Dallas 6 3/4/07 23 Chicago 1 10/1/07 34 6 3/4/07 23 Denver Please help me create condtional formatting for the example listed above. Thank You, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Conditional Formatting
Select all the D cells starting in D1 and use a CF formula of
=AND(COUNTIF($A$1:A1,A1)1,COUNTIF($B$1:B1,B1)1,C OUNTIF($C$1:C1,C1)1) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Joe K." <Joe wrote in message ... I am trying to create conditional formating for my worksheet. cell(row,column) If the value in For n= 1, end of active rows (cell(n,1) and cell(n,3) and cell(n,4)) = For i=n+1, end of active rows (cell(i,1) and cell(i,3) and cell(i,4) ) Then cell(n,5) = cell(i,5) or cell(i,5) = cell(n,5) If there is a missing for cell(n,5) or cell(i,5) then fill in the missing value. Or if cell(n,5) < cell(i,5) highlight both cells in red. From the example listed below in the third row and column 5 the value should be fill in with the value of Dallas. Listed below in the second and fourth row and column 5 both cells should highlighted in red. Example: Column1 Column3 Column4 Column5 1 10/1/07 34 Dallas 6 3/4/07 23 Chicago 1 10/1/07 34 6 3/4/07 23 Denver Please help me create condtional formatting for the example listed above. Thank You, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel | New Users to Excel | |||
Excel conditional formatting | Excel Worksheet Functions | |||
Conditional formatting in Excel | New Users to Excel | |||
Conditional Formatting in Excel | Excel Worksheet Functions | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |