Conditional Formating

  • Thread starter Thread starter Jerrold
  • Start date Start date
J

Jerrold

I have a worksheet that is for my mileage on my work vehicle. I have to keep
track of my mile is Floirda and Alabama. I am wanting to set up my worksheet
so that when I have miles in Alabama the font will change and the background
color will change. So far I have been able to do this how ever I want to copy
it to rest of the open cells below. After I have done the copy. I can start
my first row and put in the Alabama miles when I hit enter it makes all the
rows change. I want each row to work independently. How can I copy them so
this happens. I doin't want to have to format each row.
Thanks
 
Hi Jerrold

look in your conditional formatting you probably have a formula that
includes $. which makes the reference absolut, in order to work the
way you want it to you need to make it relative ($A$2 = absolute; A2 =
relative)

hth

Carlo
 
You must log in or register to reply here.

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

Formula question 5
Excel Help to copy information from one row at a time to another sheet 1
Conditional Formatting with VBA 4
Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
conditional format fails when copied 1
Conditional formatting with vba 3
Excel Conditional Formatting 1
Add to a cell if a row has a date and a column has a department 2

Back
Top