Thread
:
Changing the font of a cell dependant on the outcome
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
external usenet poster
Posts: 10,593
Changing the font of a cell dependant on the outcome
You do not need code, just Conditional Formatting.
Select the cell you wish to format, I am assuming A1 is the first
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =$A$7=10
Click the Format button
Select the Pattern Tab
Select red
OK
Click Add Condition
Change Condition 2 to Formula Is
Add a formula of =$A$7<10
Click the Format button
Select the Pattern Tab
Select black
OK
OK
Second
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Bemused Scot" <Bemused
wrote in message
...
Hi, Im pretty lost. I am trying to change the font colour of a Cell
dependant
on the answer in another cell. Also, the cells which I want to change the
colour of already have a formula inside them and I want to know if I can
add
another formula to a cell with a formula in it.
e.g a1= A32*34 and A7= 10, then if A7 =10 I want A1 to be Red, if not
black.
I want to do this for a range of cells (i.e. A1: H1) so that if A7 gives
the
number that corresponds to the result in the cell range A1:H1, it changes
the
colour of the cell within the range.
Its all a bit complicated and would love any advice. Also Im not sure if
it
is possible to do this for cells which already contain a formula
HELP
Reply With Quote
Bob Phillips
View Public Profile
Find all posts by Bob Phillips