Conditional Format

  • Thread starter Thread starter Mark M
  • Start date Start date
M

Mark M

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Format 5
Evaluating more than 30 conditions using a formula 1
Conditional Formatting 3
Conditional formatting dates 3
Condition formats have $ sign problem copying 1
copying conditon formats with $ 12
EXCEL - IF(IFERROR(VLOOKUP question 0
Copying a conditional format 2

Back
Top