select the entirerow or rows

assume you have selected rows 10:50

with A10 as the active Cell

Format
conditional Formatting

Change Cell Value is to Formula is

enter a formula like

=$D10=4

then hit the format button, patterns tab and select orange

OK out.

you enter you formula relative to the active cell. Using the $D fixes the
reference to column 4 of the appropriate row.

--
Regards,
Tom Ogilvy

"skate " wrote in message
...
Oh - is it possible to colour the entire row for the condition

so if column 4 = true then fomat the colour of the entire row for that
value to orange

Is this possible and if so can i do it through conditional formatting?


---
Message posted from http://www.ExcelForum.com/