Conditional formatting using relative refrencing

K

Kevin Harrington

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 3
Absolute to Relative Referencing 3
Altered pasting functionality 3
problem with conditional formatting and VBA (excel 2007) 0
Conditional Formatting in VB 0
Conditional Formatting macro: simple, but doesn't work 6
change font using conditional formatting 1
Need help calculating probabilities 7

Top