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

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