Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting using relative refrencing
I'm trying to incorporate conditional formatting into a spreadsheet. It
seems the formulas are absolute references. (ie) I want to set up the condition for cell A1 based on B1, then copy it to the following cells with A2 referencing B2 and A3 referencing B3. It seems the fomulas are always set to $A$1. Is there a way to change this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting using relative refrencing
Just edit the formula to remove the $ symbols
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Kevin Harrington" wrote in message ... I'm trying to incorporate conditional formatting into a spreadsheet. It seems the formulas are absolute references. (ie) I want to set up the condition for cell A1 based on B1, then copy it to the following cells with A2 referencing B2 and A3 referencing B3. It seems the fomulas are always set to $A$1. Is there a way to change this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with relative cells | Excel Discussion (Misc queries) | |||
Conditional Formatting Relative to adjacent cells | Excel Discussion (Misc queries) | |||
How do I set conditional formatting relative to another cell -XL20 | Excel Discussion (Misc queries) | |||
Setting Relative Conditional Formatting via Macro | Excel Programming | |||
Conditional Formatting Bug w/ relative formula? | Excel Programming |