Change font colour
My bad, thanks!
Gord Dibben wrote:
You can refer to another sheet for CF only if you define a name for cell on
other sheet.
i.e. defined name "apple" refers to =Sheet2!A1
Example........On Sheet1 in A1 CFFormula is: =A1<ABS(apple)
Gord Dibben MS Excel MVP
On Thu, 04 Feb 2010 08:20:31 -0600, Bob I wrote:
You need to specify the Sheet name in addition to the cell if it is not
on the same sheet eg Sheet2!A1
mturboman wrote:
I have a similar question, only my problem is i want to evaluate A1 on tab1,
vs A1 on tab2, and apply a color pattern if A1 on tab1 ABS<1 and A1 on tab2
ABS1. How can I do this, as conditional formatting does not allow other
tabs or files?
Thanks
Mike
"Stefi" wrote:
Select column B
Formats/Conditional formatting
Choose formula as criterium
Formula: =B1<A1 set format/pattern/choose pink
Regards,
Stefi
€žMin€? ezt Ã*rta:
I have 2 columns of data.
If the number in b1 is less than a1, I want the number in b1 to be displayed
in pink.
How do I do this?
Many thanks for any help!
|