Conditional Formatting help
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 |
Conditional Formatting help
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 |
Conditional Formatting help
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? |
Conditional Formatting help
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 |
Conditional Formatting help
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 |
Conditional Formatting help
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 |
Conditional Formatting help
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 |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com