Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
=Or(H6=$D$4,H6=$F$5)
should work. -- Reg "ellebelle" wrote in message ... I have more than 3 conditions in my conditional formatting, however I can get it down to just three if I use OR function, however it never seems to work. I want an array of cells (H6:K10). If a cell in an array equals a value in cell D4 or equals the value in F5 then it should be orange. I have three conditions like this. can I do it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |