Improve company productivity with a Business Account.Sign Up

x
?
Solved

I need a formula that i can use with conditional formating

Posted on 2011-09-05
1
Medium Priority
?
184 Views
Last Modified: 2012-05-12
If a certain cel contains a value,  I want the cells in the same row to become yellow.
0
Comment
Question by:itbabe
1 Comment
 
LVL 81

Accepted Solution

by:
byundt earned 2000 total points
ID: 36484663
=$A2<>""               'Note the absolute reference ($) to the column and relative reference to the row

The reference to row 2 in above formula should be to the top left cell in the range selected when you opened the Conditional Formatting menu item.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question