hi
first question...
if formula is......=IF(SUM(H4:H11)<N7,0,1)....pick your format.
this set a true/false condition for the cell that contain the CF. if
sum(h4:H11)<N7 is true, display format else it's false, dont' display format.

Second question.
not understand. more details.

regards
FSt1

"Mark M" wrote:

Hey everyone!! I have 2 question please:

1st I am trying to do a conditional format of a column for example :
=(H4:H11)<N7 then turn it orange under format. Is this the correct formula if
I am trying to say H4 thru H11? If not please show me an example!! This
formula is not working for me.

2nd If you have data on one sheet and you have you report on another sheet
. What is the conditional format formula for this? Sheet1 is called (raw
data) Sheet2 is called (report). Please give me an example!!

Thanks and have a great day!!

Mark Melancon