Conditional Formatting

[mattjhwright]

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 ro
is greater than a specified value then the value in another cell in th
row will change from 'false' to 'true'. Once that has cell has turne
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-C2
is greater than 12 then the value in C5 will change from 'false' t
'true'. The CF is set up so that if this happens then the whole ro
range C1-C23 will fill with red.

I am doing ok setting up the individual formats for each row but th
spreadsheet has 200 rows in it and i'm trying to avoid having to forma
each row individually. Is there anyway of coping/autofilling the C
down the sheet so that it takes into account the change of row

 

[Max]

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