Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of empty cell and zero value when formatting
I'd like to conditionally format a cell if the value zero is entered into it,
however to leave the cell without formatting if the cell if empty. My attempts at doing so using something like formula is =q54=0 format the cell regardless of whether the cell has a zero or is empty! Appreciate any help...thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of empty cell and zero value when formatting
Try the formula
=AND(q54<"",q54=0) -- Jacob "Al" wrote: I'd like to conditionally format a cell if the value zero is entered into it, however to leave the cell without formatting if the cell if empty. My attempts at doing so using something like formula is =q54=0 format the cell regardless of whether the cell has a zero or is empty! Appreciate any help...thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of empty cell and zero value when formatting
Works perfectly....so this is saying if the cell is not blank, and is equal
to zero, then true, so apply formatting, as apposed to if it is ony blank, which would produce a false? Brilliant...thank you, and so quick! "Jacob Skaria" wrote: Try the formula =AND(q54<"",q54=0) -- Jacob "Al" wrote: I'd like to conditionally format a cell if the value zero is entered into it, however to leave the cell without formatting if the cell if empty. My attempts at doing so using something like formula is =q54=0 format the cell regardless of whether the cell has a zero or is empty! Appreciate any help...thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of empty cell and zero value when formatting
=q54=0 will return TRUE when q54 is either blank or zero..
-- Jacob "Al" wrote: Works perfectly....so this is saying if the cell is not blank, and is equal to zero, then true, so apply formatting, as apposed to if it is ony blank, which would produce a false? Brilliant...thank you, and so quick! "Jacob Skaria" wrote: Try the formula =AND(q54<"",q54=0) -- Jacob "Al" wrote: I'd like to conditionally format a cell if the value zero is entered into it, however to leave the cell without formatting if the cell if empty. My attempts at doing so using something like formula is =q54=0 format the cell regardless of whether the cell has a zero or is empty! Appreciate any help...thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference of empty cell and zero value when formatting
Thanks for taking the extra time to explain this...helps me learn!
"Jacob Skaria" wrote: =q54=0 will return TRUE when q54 is either blank or zero.. -- Jacob "Al" wrote: Works perfectly....so this is saying if the cell is not blank, and is equal to zero, then true, so apply formatting, as apposed to if it is ony blank, which would produce a false? Brilliant...thank you, and so quick! "Jacob Skaria" wrote: Try the formula =AND(q54<"",q54=0) -- Jacob "Al" wrote: I'd like to conditionally format a cell if the value zero is entered into it, however to leave the cell without formatting if the cell if empty. My attempts at doing so using something like formula is =q54=0 format the cell regardless of whether the cell has a zero or is empty! Appreciate any help...thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting the difference between two cells | Excel Discussion (Misc queries) | |||
How can I deactivate conditional formatting if the cell is empty? | Excel Discussion (Misc queries) | |||
Leaving an empty cell empty | Excel Discussion (Misc queries) | |||
Conditional Formatting - Difference between dates | Excel Discussion (Misc queries) | |||
why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) |