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 |
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) |