| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format/compare
Perplexed-
How do I check a condtion say If(Bw=TRUE), Then compare cells D2 & D3 for equality) and repeat for about 1000 rows? Example: A B C D E 1 N TRUE If (B1=True, If(D2=D3), "MATCH") Q 2 N FALSE If (B2=True, If(D2=D3),"") Q 3 Y TRUE If (B3=True, If(D3=D4), "MATCH") Y 4 Y FALSE If (B4=True, If(D4=D5), "") Y |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Compare two Sheets with Conditional Formatting | Excel Discussion (Misc queries) | |||
| Compare two Sheets with Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional formatting - compare 2 dates | Excel Discussion (Misc queries) | |||
| Conditional Format ... Compare Columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
