| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I have a problem in Excell, which I need to fix ASAP. Please help me on this.
Pl. if possible respond to me at . In excell, if say cell A1 is having color RED, then I Want cell B3 to be RED aswell. HO w to do this. Also How to count All RED cells in a column or row?? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Do you presently have conditional formatting assigned in Cell A1 (producing
the Red)? If so, why not use the same technique with cell B3's conditional formatting? "sanjay D." wrote: I have a problem in Excell, which I need to fix ASAP. Please help me on this. Pl. if possible respond to me at . In excell, if say cell A1 is having color RED, then I Want cell B3 to be RED aswell. HO w to do this. Also How to count All RED cells in a column or row?? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Use the Formula Is, rather than Cell Value Is, option in Conditional
Formatting. -- David Biddulph "sanjay D." wrote in message ... I have a problem in Excell, which I need to fix ASAP. Please help me on this. Pl. if possible respond to me at . In excell, if say cell A1 is having color RED, then I Want cell B3 to be RED aswell. HO w to do this. Also How to count All RED cells in a column or row?? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
![sanjay D.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
