Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
I hope this will read ok.... I am trying to conditional format (CF) a spreadsheet. It has been set up so that if a value in any cell in a particular row is greater than a specified value then the value in another cell in the row will change from 'false' to 'true'. Once that has cell has turned to true, i want all the cells in that row to change colour. To clarify with numbers..... If a value in a cell in the range C6-C23 is greater than 12 then the value in C5 will change from 'false' to 'true'. The CF is set up so that if this happens then the whole row range C1-C23 will fill with red. I am doing ok setting up the individual formats for each row but the spreadsheet has 200 rows in it and i'm trying to avoid having to format each row individually. Is there anyway of coping/autofilling the CF down the sheet so that it takes into account the change of row. -- mattjhwright ------------------------------------------------------------------------ mattjhwright's Profile: http://www.excelforum.com/member.php...o&userid=25555 View this thread: http://www.excelforum.com/showthread...hreadid=389872 |
#2
|
|||
|
|||
One try ..
Assume you have this formula in C5: =COUNTIF(C6:C23,"12")0 Select rows 1* to 23 (select the row headers) Click Formatting Conditional Formatting Under condition 1, make the settings: Formula is|=$C$5 Click Format button Patterns tab Red? OK Click OK at the main dialog *assuming there's no typo in your line: .. the whole row range C1-C23 will fill with red... Test it out, if C5 evaluates to TRUE, rows1 to 23 will be filled red -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "mattjhwright" wrote in message news:mattjhwright.1sqaud_1122300305.4532@excelforu m-nospam.com... I hope this will read ok.... I am trying to conditional format (CF) a spreadsheet. It has been set up so that if a value in any cell in a particular row is greater than a specified value then the value in another cell in the row will change from 'false' to 'true'. Once that has cell has turned to true, i want all the cells in that row to change colour. To clarify with numbers..... If a value in a cell in the range C6-C23 is greater than 12 then the value in C5 will change from 'false' to 'true'. The CF is set up so that if this happens then I am doing ok setting up the individual formats for each row but the spreadsheet has 200 rows in it and i'm trying to avoid having to format each row individually. Is there anyway of coping/autofilling the CF down the sheet so that it takes into account the change of row. -- mattjhwright ------------------------------------------------------------------------ mattjhwright's Profile: http://www.excelforum.com/member.php...o&userid=25555 View this thread: http://www.excelforum.com/showthread...hreadid=389872 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |