conditional formatting

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

Conditional formatting

resolvedResolved · Low Priority · Version 2007

Jenny has attended:
Excel Intermediate course
Word Advanced course

Conditional formatting

Can you format a whole row by colour even though the criteria is only in one column?

RE: Conditional formatting

Hi Jenny

Thanks for your question

Please could you expand a little on your question. Are you looking to format a whole range based on the value in a single cell.
So for example if the first cell in the row contains a particular value, then the whole row is formatted?



Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Sun 17 Jul 2011: Automatically marked as resolved.


Excel tip:

Enter formulae into multiple cells

If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.

Just be careful with your absolute and relative cell references.

View all Excel hints and tips

Server loaded in 0.07 secs.