Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
I two rows of data, some numbers and some are N/A.
I need to highlight both rows when the top number is higher but when I use conditonal formatting it will highlight the cell contain "N/A". Is there a formula I can use to get around this? Thank you |
#2
|
|||
|
|||
try
=and(not(iserror(upper),upperlower) in your conditional format formula "sweetsue516" wrote: I two rows of data, some numbers and some are N/A. I need to highlight both rows when the top number is higher but when I use conditonal formatting it will highlight the cell contain "N/A". Is there a formula I can use to get around this? Thank you |
#3
|
|||
|
|||
bj,
It says I have too many arguments in this formula. "bj" wrote: try =and(not(iserror(upper),upperlower) in your conditional format formula "sweetsue516" wrote: I two rows of data, some numbers and some are N/A. I need to highlight both rows when the top number is higher but when I use conditonal formatting it will highlight the cell contain "N/A". Is there a formula I can use to get around this? Thank you |
#4
|
|||
|
|||
bj,
would you like to see if there is another way? "sweetsue516" wrote: bj, It says I have too many arguments in this formula. "bj" wrote: try =and(not(iserror(upper),upperlower) in your conditional format formula "sweetsue516" wrote: I two rows of data, some numbers and some are N/A. I need to highlight both rows when the top number is higher but when I use conditonal formatting it will highlight the cell contain "N/A". Is there a formula I can use to get around this? Thank you |
#5
|
|||
|
|||
Use Conditional formating under the format menu option. Use "cell is" less
than and place the cell location in the third block (A2). Condition the other cell as follows 'Cell is" Greater than and refer to the first cell (A1). Also click format in the lower right side and choose pattern from the tabs and click the color you want. You can copy the first two cells A1 and A2 and paste SPECIAL, choose "formats" when you paste special. Good luck "sweetsue516" wrote: bj, would you like to see if there is another way? "sweetsue516" wrote: bj, It says I have too many arguments in this formula. "bj" wrote: try =and(not(iserror(upper),upperlower) in your conditional format formula "sweetsue516" wrote: I two rows of data, some numbers and some are N/A. I need to highlight both rows when the top number is higher but when I use conditonal formatting it will highlight the cell contain "N/A". Is there a formula I can use to get around this? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |