Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Conditional Formating
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 -- Regards Martin D |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating in Excel | Excel Discussion (Misc queries) | |||
Conditional Formating Feature in Excel | Excel Worksheet Functions | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
Conditional formating in excel | Excel Worksheet Functions |