Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
I am having troubles setting up the conditional formating for a
worksheet. I have been trying to set up a format that highlights the cell ONLY when the value is greater than one, but it isn't working. The formating not only highlights the cell when the value is greater than 1, it also highlights the cell when the value is " ", is there any way to stop this from happening? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
In the Conditional Formatting dialog, select 'Formula Is' instead of 'Cell
Value Is'. Then, in the adjacent textbox, enter =AND(ISNUMBER(B2),B21) Set the formatting you want, and click OK to close the Conditional Formatting dialog. Hope this helps, Hutch "mastermind" wrote: I am having troubles setting up the conditional formating for a worksheet. I have been trying to set up a format that highlights the cell ONLY when the value is greater than one, but it isn't working. The formating not only highlights the cell when the value is greater than 1, it also highlights the cell when the value is " ", is there any way to stop this from happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |