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