Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The formula I wish to use for conditional formatting is:
=AND((MOD(COLUMN(),4)=1),(INDIRECT(ADDRESS(ROW(),C OLUMN()))=MIN($E17,$I17,$M17,$Q17,$U17))) If I use: =INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN($E17,$I17,$ M17,$Q17,$U17) That works correctly. The highest value in the row is highlighted. If I use: =AND((MOD(COLUMN(),4)=1),(1=1)) That works correctly. The first and every 5th column is highlighted. However, if I use: =AND((1=1),(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN( $E17,$I17,$M17,$Q17,$U17))) This does not work correctly. Nothing is highlighted. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Will Conditional Formatting work? | Excel Worksheet Functions | |||
Will Conditional Formatting work? | Excel Worksheet Functions | |||
Excel Conditional Formatting color multiple cells for 1 logical | Excel Worksheet Functions | |||
Can logical operators be used within Conditional Formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting Work around? | Excel Worksheet Functions |