Excel Conditional Formatting color multiple cells for 1 logical

[LDUNN1]

Currently, Excel Conditional formatting permits the user to format one cell
based upon the value in that cell.

I would like to see this improved upon - the ability to format multiple
cells depending upon the value of a single cell - eg a whole row or column
could be hi-lited a color depending upon the value in one of the cells in
that row or column.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions

 

[David Biddulph]

You can set conditional format for the whole of row 1 with the formula
=($B1=3), and then if B1 = 3 the whole row will be formatted.

 

[LDUNN1]

Thanks David - this works!! Just goes to show you can always learn more
tricks in Excel!!!!