Can I format an entire row based on the value of a single cell?

G

Guest

I would like to use the conditional formatting feature to format an entire
row rather than just a single cell. For example: If the cell value = "Total"
then the entire row is bold.
 
D

Dave Peterson

select your range (multiple rows???).

Then with A3 (say) the activecell in that selection:

format|Conditional formatting
formula is:
=$a3="total"
apply a nice format
 

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 Entire Row Based on single Cell Value 5
Conditional Formatting Help 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copying conditional formatting to entire sheet 3
Formatting cell 2
Conditonal Formating a entire row 2
Delete ROW based on Cell Contents 4
How can I conditional format using a range of numbers 1

Top