Conditional Format - Excel 2007

  • Thread starter Thread starter 6538
  • Start date Start date
6

6538

I want to color an entire row green where the value in column C = "Support".
I have selected condtional format > use a formula to determine which cells
to format but am not getting consistent results so something must be
incorrect with the formula.

Thanks

Lisa
 
Hi Lisa

Depending upon the range you have selected, make the formula relate to the
first row in the range but keep the column absolute
=$C2="Support"
 

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
Conditional Format text Excel 2003 2
Excel VBA 1
Conditional Formatting Question 3
conditional formatting 8
Format - Conditional Formating 3
Conditional formatting in 2007 3
Copy and Paste Conditional Formatting 3

Back
Top