Re: Conditional formatting
Hi Jay,
=A1=""
where A1 is the cell you want to test, should do it.
Cheers
PS: posting new questions in existing threads gives you less chance of
getting an answer.
--
macropod
[MVP - Microsoft Word]
"Jay" <zeugma@xxxxxxxxxxxxxx> wrote in message
news:C0AC2FD4.1BCC%zeugma@xxxxxxxxxxxxxxxxx
I am trying to conditionally format a range of cells - simply filling them
in grey if they are empty. However, they contain the following:
=If(A1>0,A1/B1,"")
What condition can I use to fill this cell if indeed it contains "" ?
Many TIA
Jay
___
.
Relevant Pages
- Re: MSHFlexGrid ShowCaret...
... > Sorry for the multiple postings. ... That makes sure that A) you get answers (by posting to more than ... I don't think you'll be able to get a caret to show in a flexgrid cell ... without using the "hidden textbox" method. ...
(microsoft.public.vb.general.discussion) - RE: Excel 2007 cell reference problems
... Please also help me to capture somes screenshots to show the symptom in ... This posting is provided "AS IS" with no warranties, ... Excel 2007 cell reference problems ... | The physical cell can contain any number. ...
(microsoft.public.office.misc) - Re: copy values from 11 books to 1 sheet
... I will do a posting for it, maybe I can get help about it ... that TELLS Excel to look in the CURRENT PATH. ... over to the Book1 window, select the Sheet2 tab and then click on ... sheetname and cell reference. ...
(microsoft.public.excel) - RE: Transpose a data table
... I said in my previous posting that the Room Numbers had ... Assum this formula is in cell H2 and the original table is located A1:C10 ... finally you have $C$2:$C$10 which produces an array of the numbers in column ... "jbjtc" wrote: ...
(microsoft.public.excel.misc) - Re: macro to look down cells and if negative in the right of the c
... posting) to my latest solution I forgot to remove the 1 from the string. ... "Dave Peterson" wrote: ... For Each cell In ColumnRange ...
(microsoft.public.excel.programming) |
|
