Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to use conditional formatting on a range of cells when the cell
to the left of it matches a certain criteria along with less than or equal to cell. b4:b367 contains values of Saturday, Sunday, etc c4:c367 is a numeric field that I am inputting c371 is a numeric value So, when any one of the cells in c4:c367 is less than or equal to c371 and the criteria in b4:b367 matches (for example) "Saturday", I want the cell to highlight. Can someone please offer me up a solution on how to type the formula in? Thank youin advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - Excel 2007 | Excel Discussion (Misc queries) | |||
More Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
conditional formatting in Excel 2007 - help, please! | New Users to Excel | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional formatting in Excel 2007 | New Users to Excel |