Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
copy conditional format to regular format | Setting up and Configuration of Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |