| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I conditionally format 1 cell to look at 5 cells
I am trying to have 1 cell look at 5 cells and change color if any one of the
5 matches the 1 cell |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I conditionally format 1 cell to look at 5 cells
Assume the 5 cells are B1:B5, and A1 is the formatted cell:
=COUNTIF(B1:B5,A1)0 -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "DFRESH" wrote: I am trying to have 1 cell look at 5 cells and change color if any one of the 5 matches the 1 cell |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can I conditionally format 1 cell to look at 5 cells
CF/ Formula Is:
=OR(A1=F1,B1=F1,C1=F1,D1=F1,E1=F1) -- David Biddulph DFRESH wrote: I am trying to have 1 cell look at 5 cells and change color if any one of the 5 matches the 1 cell |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conditionally format only some of the text in a cell? | Excel Worksheet Functions | |||
| How to Conditionally Format Other Cells or Rranges | Excel Discussion (Misc queries) | |||
| how can I conditionally format a cell Part 2 | Excel Discussion (Misc queries) | |||
| How can I conditionally format cells that contain formulas? | Excel Discussion (Misc queries) | |||
| conditionally format cells | Excel Worksheet Functions | |||
Hybrid Mode
