| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating a Block of Cells
I am needing to apply a conditional format to a block of cells (13 rows x 8
columns) based on a value inside this block. I have tried the conditional format but it only seems to affect A1 Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating a Block of Cells
What is your CF function?
I tried Value is equal to =$B$3 (absolute reference) on columns B and C and it highlighted all cells, including B3 which matched. HTH "TonTon165" wrote: I am needing to apply a conditional format to a block of cells (13 rows x 8 columns) based on a value inside this block. I have tried the conditional format but it only seems to affect A1 Please help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating a Block of Cells
Thanks, the absolute reference worked
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another Conditional Formating Question | Excel Worksheet Functions | |||
| Use conditional formating to incicate blank cells in excel | Excel Worksheet Functions | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
| Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
| How to copy block of cells and keep grouping? | Excel Discussion (Misc queries) | |||
Linear Mode
