formatting problem

  • Thread starter Thread starter srv5uk
  • Start date Start date
S

srv5uk

How can I get Excel to change to colour of an entire row when I enter
data in a specific cell?

ie

If I have data in the cell range A1...G1 and then I enter data in H1
I want Excel to change the colour of the entire row to indicate that
the task is complete for that row, but still leave the data readable


Thanks in advance
 
Hi
It sounds like you need conditional formatting (from the Format menu). Do
you need a specific entry in H1, or just anything?

Andy.
 
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

Conditional formatting in Excel 2010 2
Can you conditionally format a whole row based on data in one cel 1
Conditional Formating based on Data Validation 3
Conditional formatting 3
condition format 2
Remove colour change 4
Question about conditional formatting of zeros in Excel 0
Excel How to find the most common pairs and triplets numbers? 5

Back
Top