Take a look at script triggers. OnObJectSave, for example, can be set on a field such that when you change its value and exit, it performs a script. The script can use the value of the field to determine what should happen next.
Well there are script triggers. In Layout Mode, right click on a field, click 'Set Script Triggers", and you can pick the one you like and when you click "Select" it will take you to "Specify Script" where you can click the "+" button at the bottom and write the script you need.
edit: Phil types faster.........
Thanks Phil and Steve. That was easy :) I was so fixated on using the conditional formatting cause I was playing around with it, that I forgot I can use script trigger. So I guess I can use "OnRecordLoad" so that when a certain record with a field that meets that criteria it will trigger the script or go to a specific Layout. Perfect!