hey all,

you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?

thanks,
rodchar

Can you give an example of the condition to be met?


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109666

Like formulas, you can secure it with the $ sign
Eg with the entire sheet selected (A1 active)
applying CF using Formula Is: =$A1<""
will colour entire rows where col A is not empty
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"rodchar" wrote:
you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?

For instance,

i have a column that contains 2 possible values (TRUE or FALSE)

i'd like to highlight all the rows that are FALSE by changing the back color

"NBVC" wrote:


Can you give an example of the condition to be met?


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109666

Say, for argument's sake, the column of interest is Column A....

Then select the entire range to include in the highlighting event.

Go to Format|Conditional Formatting and select Formula Is from the 1st
drop down menu.

Enter formula like: =$A1=FALSE where A1 is the top-most cell in the
column of TRUEs/FALSEs.

Note the $ in front of the A, it "freezes" the Column so that all
conditions in all columns always look at column A for the conditional
request.

Then click Format and choose from the Pattern tab to complete.


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109666

Great, thanks everyone for the help,
rod.

"rodchar" wrote:

hey all,

you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?

thanks,
rodchar

Thanks everyone for the help,
rod.

"rodchar" wrote:

hey all,

you know how you can select a column for conditional formatting, well, i was
wondering if there was a way to highlight the whole row if the condition is
met?

thanks,
rodchar