How to enter a function when the argument is the cell value itself?

[Jack]

I'm trying to use conditional formatting at some cells, and the
condition will contain =FUNCTION('this very cell value'). Is this
possible?

Thanks!

 

[Frank Kabel]

Hi
within the conditional format dialog this is possible:
- select the cell (lets say cell A1)
- goto 'format - conditional format'
- enter the formula (as an example)
=ISNUMBER(A1)
- choose a format

this will format A1 if it's a number and not blank or a text value

 

[Dave Peterson]

Just use the cell's address.

=abs(a1)<6

for example (if A1 were the active cell)

 

[JMay]

With Cell A1 current, do Format, Cond Formatting
Choose FunctionIs Box and enter =A1=$A$1

 

[AlfD]

Hi!

I suspect that most conditional formatting is dependent on the value o
the cell being formatted. Use "Formula is" from the list box and yo
can do things like make it show red if the chosen cell (A1, say
satisfies a condition such as =23*A1>700. (Not that you'd want to, o
course).

Al

 

[Jack]

Hi!

I suspect that most conditional formatting is dependent on the value of
the cell being formatted. Use "Formula is" from the list box and you
can do things like make it show red if the chosen cell (A1, say)
satisfies a condition such as =23*A1>700. (Not that you'd want to, of
course).

Alf

Thank you all, but that's not exactly what I asked.

Let me use this example:
I need to use conditional formatting on 50 cells A1, A2… A50.
Obviously, I don't want to specify the conditional formatting on each
individual cell 50 times. I can't write the condition as ABS(A1) < 6
(for cell A1) and copy/paste to 49 other cells because I would like it
to be ABS(A2) < 6, ABS(A3) < 6, …, ABS(A50) < 6. So that's my problem.

 

[Jack]

Hi!

I suspect that most conditional formatting is dependent on the value of
the cell being formatted. Use "Formula is" from the list box and you
can do things like make it show red if the chosen cell (A1, say)
satisfies a condition such as =23*A1>700. (Not that you'd want to, of
course).

Alf

Please ignore my previous post. Your solution actually solved my
problem. I just messed up my formula so badly that it couldn't work