M
Martin D
I have created a spreedsheet with a formula in CELL G133, which enters a text
sring contained in another Cell(s) dependant on the condition (result) of a
number in Cell F133. This works fine using the IF command.
CELL G133 Formula is =IF(F133<=4,T133,T134)
I now wish to change the colour of CELL G133 dependant on the Result of the
number in CELL F133 using conditional format. I have read most of the Q&A and
tried a few of them out. such as using Formula IS =f133<=4 turn cell to Green
but this does not appear to work. WHAT I AM DOING WRONG?
As a sup question I wish to have 4 different conditions but Excell 2003 only
appears to offer 3 options for conditional formating.
HELP PLEASE
sring contained in another Cell(s) dependant on the condition (result) of a
number in Cell F133. This works fine using the IF command.
CELL G133 Formula is =IF(F133<=4,T133,T134)
I now wish to change the colour of CELL G133 dependant on the Result of the
number in CELL F133 using conditional format. I have read most of the Q&A and
tried a few of them out. such as using Formula IS =f133<=4 turn cell to Green
but this does not appear to work. WHAT I AM DOING WRONG?
As a sup question I wish to have 4 different conditions but Excell 2003 only
appears to offer 3 options for conditional formating.
HELP PLEASE