Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I use conditional formatting a lot. Many times on a single worksheet. I use the IF formula to decide if the condition is true or false. Problem is, to save time, i 'auto fill' the conditional formatting. In conditional formatting though, when I enter the formula, the cell references become 'fixed' (ie $ use). Because I use auto fill, I dont want the $ used. Is there a way I can avoid using it?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
On Sunday, February 24, 2013 11:33:35 AM UTC+13, Esradekan wrote:
I use conditional formatting a lot. Many times on a single worksheet. I use the IF formula to decide if the condition is true or false. Problem is, to save time, i 'auto fill' the conditional formatting. In conditional formatting though, when I enter the formula, the cell references become 'fixed' (ie $ use). Because I use auto fill, I dont want the $ used. Is there a way I can avoid using it? Oh, I am currently using Excel 2013, but same has applied to all Excel's I have used) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
Esradekan has brought this to us :
On Sunday, February 24, 2013 11:33:35 AM UTC+13, Esradekan wrote: I use conditional formatting a lot. Many times on a single worksheet. I use the IF formula to decide if the condition is true or false. Problem is, to save time, i 'auto fill' the conditional formatting. In conditional formatting though, when I enter the formula, the cell references become 'fixed' (ie $ use). Because I use auto fill, I dont want the $ used. Is there a way I can avoid using it? Oh, I am currently using Excel 2013, but same has applied to all Excel's I have used) Well.., just don't type the $ symbol when you enter the formula. If it appears as the result of selecting ranges then edit that out using F2 while your in the edit box. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
On Sunday, February 24, 2013 11:33:35 AM UTC+13, Esradekan wrote:
I use conditional formatting a lot. Many times on a single worksheet. I use the IF formula to decide if the condition is true or false. Problem is, to save time, i 'auto fill' the conditional formatting. In conditional formatting though, when I enter the formula, the cell references become 'fixed' (ie $ use). Because I use auto fill, I dont want the $ used. Is there a way I can avoid using it? Never mind, I have sorted it out - Thank you. Esra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
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 that will display conditional data | Excel Worksheet Functions |